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