Function Expressions

A function expression represents any valid function that you can use within the framework.

Syntax

function_expression ::= general_function | aggregate_function | window_function | macro_call| datatype_function

Function expressions include:

• General Functions: Standard functions used for various computations or transformations.
• Aggregate Functions: Functions that perform calculations over groups of rows (Example: SUM, AVG).
• Window Functions: Functions that compute values over a range of rows within a partition (Example: ROW_NUMBER, RANK).
• Macro Calls: Calls to user-defined macros applied to columns or parameters.
• Datatype Functions: Functions specific to certain data types (Example: casting or type-specific operations).