📄️ IF
IF( <expr1>, <expr2>, <expr3> ) function
📄️ IFNULL
IFNULL( <expr1>, <expr2> ) function
📄️ IN
Tests whether the argument is or is not one of the members of an explicit list
📄️ IS [NOT] DISTINCT_FROM
<expr1> IS [NOT] DISTINCT FROM <expr2> function
📄️ IS_NOT_NULL
is_not_null( <expr> ) function
📄️ IS_NULL
IS_NULL( <expr> ) function
📄️ MULTI_IF
MULTI_IF( <expr1>, <expr2>, <expr3> ) function
📄️ NULLIF
NULLIF( <expr1>, <expr2> ) function