Derive

Computes one or more new columns.

Examples

PRQL

1. from employees
2. derive gross_salary = salary + payroll_tax

SQL

1. SELECT
2. *,
3. salary + payroll_tax AS gross_salary
4. FROM
5. employees

PRQL

1. from employees
2. derive [
3. gross_salary = salary + payroll_tax,
4. gross_cost = gross_salary + benefits_cost
5. ]

SQL

1. SELECT
2. *,
3. salary + payroll_tax AS gross_salary,
4. salary + payroll_tax + benefits_cost AS gross_cost
5. FROM
6. employees