Expressions

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)