*
FROM

PRQL

SQL

SELECT
  *,
  salary + payroll_tax AS gross_salary
FROM
  employees

WITH table_1 AS (
  SELECT
    name,
    salary + payroll_tax AS gross_salary,
    dept_no
  FROM
    employees AS e
  LIMIT
    10
)
SELECT
  table_0.name,
  table_0.gross_salary,
  d.name
FROM
  JOIN department AS d ON table_0.dept_no = d.dept_no

• - PRQL Transforms