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 (Done)
- Bitwise Expression Functions Perform bitwise operations and manipulations (Done)
- Conditional Expression Functions Implement conditional logic and case statements (Done)
- Context Functions Provide information about the current SQL execution context (Done)
- Conversion Functions Convert data types and cast values (done)
- Date & Time Functions Manipulate and format dates and times
- Geospatial Functions Handle and manipulate geospatial data (Done)
- Numeric Functions Perform calculations and numeric operations (Done)
- String Functions Manipulate strings and perform regular expression operations (Done)
- 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 (Done)
Specialized Functions
- Hash Functions Generate hash values for data security and comparison (Done)
- IP Address Functions Manipulate and analyze IP address data (Done)
- UUID Functions Generate and manipulate UUIDs (Done)
System and Table Functions
- System Functions Access system-level information and perform control operations (Done)
- Table Functions Return results in a tabular format (Done)
Other Functions
- Other Miscellaneous Functions A collection of various other functions (Done)
AI Functions
Using SQL-based AI Functions for Knowledge Base Search and Text Completion