3 ms·
> As an example why would WHERE clauses need to have a AND instead of multiple WHERE clauses. PRQL does this: from employees filter country_code == "U
by snthpy 4y ago
> As an example why would WHERE clauses need to have a AND instead of multiple WHERE clauses.
PRQL does this:
from employees
filter country_code == "USA" # Each line transforms the previous result.
filter age > 50
compiles to:
SELECT
*
FROM
employees
WHERE
country_code = 'USA'
AND age > 50
-- Generated by PRQL compiler version 0.3.1 (https://prql-lang.org)
- Sammyadems1 4y agoWhat about an OR in the where? or Parens with multibuls ANDs and ORs