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 (department | in ["IT", "HR"])

SQL

  1. SELECT
  2.   *
  3. FROM
  4.   employees
  5. WHERE
  6.   department IN ('IT', 'HR')

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