Filter

Picks rows based on their values.

filter {boolean_expression}

Examples

PRQL

from employees
filter age > 25

SQL

SELECT
  employees.*
FROM
  employees
WHERE
  age > 25

PRQL

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

SQL

SELECT
  employees.*
FROM
  employees
WHERE
  age BETWEEN 25
  AND 40