Filter

Picks rows based on their values.

filter boolean_expression

Examples

from employees
filter age > 25

SELECT
  *
FROM
  employees
WHERE
  age > 25

from employees
filter (age > 25 || department != "IT")

SELECT
  *
FROM
  employees
WHERE
  age > 25
  OR department <> 'IT'

from employees
filter (department | in ["IT", "HR"])

SELECT
  *
FROM
  employees
WHERE
  department IN ('IT', 'HR')

from employees
filter (age | in 25..40)

SELECT
  *
FROM
  employees
WHERE
  age BETWEEN 25 AND 40