Aggregate functions
Compute a single result from a set of input values.
Array functions and operators
Manage lists and collections of data.
Binary string functions and operators
Handle binary data formats.
Comparison functions and operators
Check if values are equal, greater, or less than others.
Conditional expressions
Verify specific conditions.
Cryptographic functions
Perform encryption and decryption of data.
Date and time functions and operators
Modify date, time, and timestamp data.
JSON functions and operators
Parse JSON-structured data.
Logical operators
Use boolean values combine statements.
Map functions and operators
Transform data structures with key-value mapping.
Mathematical functions and operators
Perform numerical calculations and analysis.
Set-returning functions
Return a set or table of data.
String functions and operators
Process textual data.
System administration functions
Manage database operations and settings.
System information functions
Retrieve database configuration details.
Time windows
Group events and perform calculations.
Window functions
Compute results for each row over a set of rows.