select

DefinitionCopy Anchor Link

Run one expression or multiple expression over each row of a table and use the output to return a new table with the same number of row. In AQL, the select function serves as an intermediate step for subsequent transformations.

Syntax

select(table, expr1, expr2, ...)
select(table, col_name: expr1, ...)

select(orders, orders.id, orders.status) // -> Table(orders.id, orders.status)

// with pipe
orders | select(orders.id, orders.status) | select(orders.id) // -> Table(orders.id)

// named column
orders | select(orders.status, formatted_status: concat('Status: ', orders.status))

Input

• table: A model reference or the returned table from a previous expression.
• expr (repeatable): An expression to evaluate for each row of table.

Output

A table with the same number of rows as the input table, but with only the specified columns. E.g. select(orders, orders.id, formatted_status: concat('Status: ', orders.status) will return a table with 2 columns: orders.id and formatted_status.

Sample UsagesCopy Anchor Link

order_items | select(
  countries.name, 
  products.name,
  value: order_items.quantity * products.price
)

order_items | select(value: order_items.quantity * products.price) | sum(value)

See alsoCopy Anchor Link

• filter()
• group()
• unique()
• Pipe operator