π PRQL - Pipelined Relational Query Language
PRQL Pipelined Relational Query Language, pronounced βPrequelβ PRQL is a modern language for transforming data β a simple, powerful, pipelined SQL replacement For example, βTop N by groupβ: from employees group role ( sort join_date take 1 ) WITH table_0 AS ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY role ORDER BY join_date ) AS _expr_0 FROM employees ) SELECT * FROM table_0 WHERE _expr_0 <= 1