Table Functions

Table functions transform an input table expression into an output table result.

Function	Syntax	Purpose
select	select(table, field1, field2, [,...])	Selects the fields to be returned in the query result.
group	group(table, field1, field2, [,...])	Groups the result set by the specified field(s).
filter	filter(table, condition1, condition2, [,...])	Filters the result set to include only rows that satisfy the specified conditions
unique	unique(table, field1, field2, [,...])	Returns the unique values of the specified field(s).