PRQLPipelined Relational Query Language, pronounced “Prequel”PRQL is a modern language for transforming data— a simple, powerful, pipelined SQL replacement from invoices filter invoice_date >= @1970-01-16 derive { transaction_fees = 0.8, income = total - transaction_fees } filter income > 1 group customer_id ( aggregate { average total, sum_income = sum income, ct = count total, } ) sort {-sum_income}
