Picks rows based on their values.
filter boolean_expression
from employees
filter age > 25
SELECT
*
FROM
employees
WHERE
age > 25
from employees
filter (age > 25 || department != "IT")
SELECT
*
FROM
employees
WHERE
age > 25
OR department <> 'IT'
from employees
filter (age | in 25..40)
SELECT
*
FROM
employees
WHERE
age BETWEEN 25 AND 40