📄️ ASSUME_NOT_NULL
Results in an equivalent non-Nullable value for a Nullable type. In case the original value is NULL the result is undetermined.
📄️ COALESCE
Checks from left to right whether NULL arguments were passed and returns the first non-NULL argument.
📄️ EXISTS
The exists condition is used in combination with a subquery and is considered "to be met" if the subquery returns at least one row.
📄️ HUMANIZE_NUMBER
Returns a readable number.
📄️ HUMANIZE_SIZE
Returns the readable size with a suffix(KiB, MiB, etc).
📄️ IGNORE
By using insert ignore statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.
📄️ TO_NULLABLE
Converts the argument type to Nullable.
📄️ TYPEOF
TYPEOF function is used to return the name of a data type.