SQL functions

48 functions. Compute one result from a set of rows, such as a sum, count, average or approximate distinct count. Most can also run as window functions.

7 functions. Rank rows and read values from neighbouring rows within a window. Aggregate functions can also run over windows.

23 functions. Branch on conditions, handle NULLs, cast between types and read session context.

63 functions. Search, slice, combine, pad, format and transform text.

78 functions. Build, convert, format, extract from and do arithmetic on dates, times and timestamps.

53 functions. Arithmetic, rounding, logarithmic, trigonometric and other numeric functions.

12 functions. Parse JSON, extract values from it and build JSON output.

34 functions. Build, inspect, transform and flatten arrays.

7 functions. Build maps and read their keys, values and entries.

2 functions. Build structs (records with named fields).

9 functions. Functions that return rows instead of a single value, such as exploding arrays or generating ranges.

8 functions. Match, extract and replace text with regular expressions.

5 functions. Compute checksums and cryptographic digests.

13 functions. Operate on the individual bits of integers.

1 functions. Work with bitmaps.

H3 and spatial functions for points, coordinates and polygons.

3 pages. Statements and clauses that aren’t functions: unloading results to object storage, grouping at several levels, and excluding columns or rows.