Expressions
Standard Expressions are basic level operations that can be added across the platform such as finding the max value in a column, extracting the year from a date field, or removing the leading zeroes in a text field.
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
- Numeric Functions Perform calculations and numeric operations
- String Functions Manipulate strings and perform regular expression operations
- Searcg Functions Find values using expressions
- Semi-structured and Structured Data Functions Work with JSON and other structured data formats
Aggregate Functions
- Aggregate Functions Calculate summaries like sum, average, count, etc...
- Window Functions Provide aggregate calculations over a specified range of rows
AI Functions
- AI Functions Leverage AI and machine learning capabilities
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
- System Functions Access system-level information and perform control operations
- Table Functions Return results in a tabular format
Other Functions
- Other Miscellaneous Functions A collection of various other functions
- Dictionary Functions Dictionary functions
Full Index
AI Functions
Using SQL-based AI Functions for Knowledge Base Search and Text Completion