Static
serializeSQL IS DISTINCT FROM operator - null-safe inequality comparison Returns true when values are different, treating NULL as a known value NULL IS DISTINCT FROM NULL = false NULL IS DISTINCT FROM value = true value IS DISTINCT FROM value = false
SQL IS NOT DISTINCT FROM operator - null-safe equality comparison Returns true when values are the same, treating NULL as a known value NULL IS NOT DISTINCT FROM NULL = true NULL IS NOT DISTINCT FROM value = false value IS NOT DISTINCT FROM value = true
SQL IS NOT NULL operator - checks if the value is not null
SQL IS NULL operator - checks if the value is null
SQL OVER clause - converts an aggregate function to a window function Can be used with partition by and order by specifications
Optional
spec: WindowSpecStatic
newStatic
parseStatic
subtypeStatic
type
SQL CAST operator - converts a value to a different type CAST(expression AS target_type)