Logical Operators and Conditional and Subquery Expressions

Logical Operator Support
Operator
Description
AND
Logical AND
NOT
Negates value
OR
Logical OR
Conditional Expression Support
Expression
Description
CASE WHEN condition THEN result ELSE default END
Case operator
COALESCE(val1, val2, ..)
Returns the first non-null value in the list
Geospatial and array column projections are not supported in the COALESCE function and CASE expressions.
Subquery Expression Support
Expression
Description
expr IN (subquery or list of values)
Evaluates whether expr equals any value of the IN list.
expr NOT IN (subquery or list of values)
Evaluates whether expr does not equal any value of the IN list.
Usage Notes
You can use a subquery anywhere an expression can be used, subject to any runtime constraints of that expression. For example, a subquery in a CASE statement must return exactly one row, but a subquery can return multiple values to an IN expression.
You can use a subquery anywhere a table is allowed (for example, FROM subquery), using aliases to name any reference to the table and columns returned by the subquery.

Arrays

Table Expression and Join Support

Last modified 6mo ago

Operator	Description
`AND`	Logical AND
`NOT`	Negates value
`OR`	Logical OR

Expression	Description
`CASE WHEN condition THEN result ELSE default END`	Case operator
`COALESCE(val1, val2, ..)`	Returns the first non-null value in the list

Expression	Description
`expr IN (subquery or list of values)`	Evaluates whether expr equals any value of the IN list.
`expr NOT IN (subquery or list of values)`	Evaluates whether expr does not equal any value of the IN list.