Set/Relational Functions

Functions operating on sets or relations.

Union

Combines the results of two or more compatible inputs (concepts or queries) into a single result set. Behaves like UNION ALL (does not remove duplicates). The inputs must have compatible data types.

Inputs:

Any (compatible concepts/queries)...

Output:

Depends on inputs (structure of the combined set)

Purpose:

key

Example:

SELECT * FROM UNION(active_customers, recently_lapsed_customers);

Group

Explicitly specifies the grouping keys for an expression, often used with aggregate functions when a different grain is needed than the main query `BY` clause. The first argument is the expression to aggregate/group, subsequent arguments are the keys. Syntax is distinct in that is is group key by <over clause>, similar to a group by.

Inputs:

Any (expression)Any (key)...

Output:

Same as first argument's type

Purpose:

property

Example:

SELECT SUM(revenue) AS total_revenue, GROUP SUM(revenue) BY product_category AS revenue_by_category, customer_id;