| GENERATE_UUID | Generates a random UUID version 4 (RFC 4122) value. Returns a native UUID type that can be used directly in UUID columns or cast to other types. |
| IS [NOT] DISTINCT FROM | Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values. |
| ISDATE | Returns true if the input expression can be cast to a date. |
| IS [NOT] FALSE | Tests whether the input expression is either false or not false. If true in either case, returns a value of true. Alias for the function ISFALSE/ISNOTFALSE. |
| IS [NOT] NULL | Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL. |
| IS [NOT] TRUE | Tests whether the input expression is either true or not true. If true in either case, returns a value of true. Alias for the function ISTRUE/ISNOTTRUE. |
| IS_BIGINT | Returns TRUE if the input expression is a BIGINT value. |
| IS_BOOLEAN | Returns TRUE if the input expression is a VARIANT<BOOLEAN>. |
| IS_DATE | Returns TRUE if the input expression is a VARIANT<DATE>. |
| IS_DECIMAL | Returns TRUE if the input expression is a VARIANT<DECIMAL>. |
| IS_DOUBLE | Returns TRUE if the input expression is a VARIANT<DOUBLE>. |
| IS_FLOAT | Returns TRUE if the input expression is a VARIANT<FLOAT>. |
| IS_INT | Returns TRUE if the input expression is an integer value. |
| IS_LIST | Returns TRUE if the input expression is a VARIANT<ARRAY>. |
| IS_STRUCT | Returns TRUE if the input expression is a VARIANT<STRUCT>. |
| IS_SUBSTR | Returns true if a string is contained within another string. The comparison is case-sensitive. |
| IS_TIMESTAMP | Returns TRUE if the input expression is a VARIANT<TIMESTAMP>. |
| IS_TIME | Returns TRUE if the input expression is a VARIANT<TIME>. |
| IS_UUID | Returns TRUE if the input expression is a VARIANT<UUID>. |
| IS_VARBINARY | Returns TRUE if the input expression is a VARIANT<VARBINARY>. |
| IS_VARCHAR | Returns TRUE if the input expression is a VARCHAR value. |
| IS_VARIANT_NULL | Returns TRUE if the input expression is a VARIANT<NULL> (as opposed to SQL NULL). |
| SIZE | Returns the number of entries in a map expression. |
| TYPEOF | Reports the type (in string format) of the input expression. |