String Functions
Text manipulation: UPPER, LOWER, CONCAT, SUBSTRING, TRIM, and more
Date & Time Functions
Temporal operations: DATE_TRUNC, DATE_ADD, FORMAT_TIMESTAMP, and more
Numeric Functions
Math operations: ROUND, ABS, CEIL, FLOOR, SQRT, and more
Aggregate Functions
GROUP BY computations: COUNT, SUM, AVG, MIN, MAX, and more
Array & Map Functions
Collection operations: SIZE, ELEMENT_AT, ARRAY_FLATTEN, and more
Window Functions
Ranking and analytics: ROW_NUMBER, RANK, LAG, LEAD, and more
Geospatial Functions
Geographic calculations: ST_GeoHash, ST_Distance, and more
Narrative Functions
Platform-specific: DELTA, budget functions, and more
Conditional Functions
Conditional logic: IF, COALESCE, NULLIF, CASE