Filter

Picks rows based on their values.

filter {boolean_expression}

Examples

PRQL

from employees
filter age > 25

SQL

SELECT
  *
FROM
  employees
WHERE
  age > 25

PRQL

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

SQL

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

PRQL

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

SQL

SELECT
  *
FROM
  employees
WHERE
  age BETWEEN 25 AND 40