Lakehouse v1 Expressions

Lakehouse v1 expressions based on Databend SQL functions with SQLAlchemy references using func. prefixes.

Scalar Functions

Array Functions — Perform array operations
Bitwise Expression Functions — Perform bitwise operations and manipulations
Conditional Expression Functions — Implement conditional logic and case statements
Context Functions — Provide information about the current SQL execution context
Conversion Functions — Convert data types and cast values
Date & Time Functions — Manipulate and format dates and times
Geospatial Functions — Handle and manipulate geospatial data
Geometry Functions — Handle and manipulate geospatial geometry data
Interval Functions — Create and manipulate time intervals
Map Functions — Create and manipulate map data structures
Numeric Functions — Perform calculations and numeric operations
Search Functions — Find values using expressions
Semi-structured and Structured Data Functions — Work with JSON and other structured data formats
String Functions — Manipulate strings and perform regular expression operations

Aggregate Functions — Calculate summaries like sum, average, count, etc.
Window Functions — Provide aggregate calculations over a specified range of rows

Sequence Functions — Generate sequential values
System Functions — Access system-level information and perform control operations
Table Functions — Return results in a tabular format