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 or 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