FILTER function

Returns a table that has been filtered based on a specified condition.

Syntax

filter(<table>, <filter>)

Parameter	Type	Description
table	vt	The table to be filtered.
filter	bool	A boolean (True/False) expression to be evaluated for each row of the table.

Usages

filter(orders, orders.discount == 0)

filter(customers, is_empty(customers.last_ordered_at))