SQL functions

e6data SQL functions by category - aggregate, array, date and time, JSON, mathematical, string, window, and more.

Reference for the built-in SQL functions e6data supports, grouped by category.

Category	Functions for
Aggregate	Summarizing rows - SUM, AVG, COUNT, and related
Array	Working with array values
Bitwise	Bit-level operations on integers
Cardinality estimation	Approximate distinct counts
Checksum	Hashing and checksums
Comparison	Comparison operators and predicates
Conditional	CASE, COALESCE, and conditional logic
Conversion	Casting between data types
Date and time	Date/time math, extraction, formatting, and time zones
Generate	Generating rows and sequences
Geospatial	Location data and H3 functions
JSON	Parsing and extracting from JSON
Logical operators	AND, OR, NOT
Mathematical	Arithmetic, exponential, logarithmic, rounding, and trigonometric
Regex	Regular-expression matching and extraction
Statistical	Statistical aggregates
String	Text manipulation and pattern matching
Struct	Working with struct values
Window	Window and analytic functions

See also

• SQL commands - supported SQL statements