Table Expressions
Table expressions in AQL are queries that return tabular output, letting you chain table functions with the pipe operator to filter, select, and join data.
Table expressions are expressions that represent a query that returns a table output, similar to SQL. They are typically Table Functions combined using the AQL pipe operator.
Structure
model_name
| table_function1 (optional)
| table_function2 (optional)
| ...Examples
This table expresion is equivalent to select * from users in SQL:
usersSelecting a subset of fields:
users | select(users.id, users.gender)Filtering data with filter function:
users
| filter(gender == 'Female')
| select(id, name)There is no need for explicitly joins like in SQL for cross-model select:
users
| select(users.name, country.name)AQL Expression
What AQL expressions are, the two kinds (table and metric), how the pipe operator chains functions together, and the dataset context every expression needs.
Metric Expressions
AQL metric expressions cover composing aggregations, setting a source table, and applying metric context (filters, LOD, window functions) via pipe syntax.