Filter

Picks rows based on their values.

  1. filter boolean_expression

Examples

PRQL

  1. from employees
  2. filter age > 25

SQL

  1. SELECT
  2. *
  3. FROM
  4. employees
  5. WHERE
  6. age > 25

PRQL

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

SQL

  1. SELECT
  2. *
  3. FROM
  4. employees
  5. WHERE
  6. age > 25
  7. OR department <> 'IT'

PRQL

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

SQL

  1. SELECT
  2. *
  3. FROM
  4. employees
  5. WHERE
  6. age BETWEEN 25 AND 40