Lakehouse v1 Expressions
Lakehouse v1 is built on the Databend SQL engine. For each function below, this site provides PlaidCloud-flavored syntax and examples; for the canonical upstream reference (with all edge cases and argument variants), see the Databend SQL function reference.
Scalar Functions
Section titled “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
Section titled “Aggregate Functions”- Aggregate Functions — Calculate summaries like sum, average, count, etc.
- Window Functions — Provide aggregate calculations over a specified range of rows
AI Functions
Section titled “AI Functions”- AI Functions — Leverage AI and machine learning capabilities
Specialized Functions
Section titled “Specialized Functions”- Hash Functions — Generate hash values for data security and comparison
- IP Address Functions — Manipulate and analyze IP address data
- UUID Functions — Generate and manipulate UUIDs
System and Table Functions
Section titled “System and Table Functions”- Sequence Functions — Generate sequential values
- System Functions — Access system-level information and perform control operations
- Table Functions — Return results in a tabular format
Other Functions
Section titled “Other Functions”- Dictionary Functions — Work with dictionary data structures
- Other Miscellaneous Functions — A collection of various other functions
- Test Functions — Functions used for testing purposes