Select

Picks and computes columns.

select [
  {name} = {expression},
  # or
  {column},
]
# or
select ![{column}]

Examples

from employees
select name = f"{first_name} {last_name}"

SELECT
  CONCAT(first_name, ' ', last_name) AS name
FROM
  employees

from employees
select [
  name = f"{first_name} {last_name}",
  age_eoy = dob - @2022-12-31,
]

SELECT
  CONCAT(first_name, ' ', last_name) AS name,
  dob - DATE '2022-12-31' AS age_eoy
FROM
  employees

from employees
select first_name

SELECT
  first_name
FROM
  employees

from e=employees
select [e.first_name, e.last_name]

SELECT
  first_name,
  last_name
FROM
  employees AS e

Excluding columns

We can use ! to exclude a list of columns. This can operate in two ways:

• We use SELECT * EXCLUDE / SELECT * EXCEPT for the columns supplied to select ![] in dialects which support it.
• Otherwise, the columns must have been defined prior in the query (unless all of a table’s columns are excluded); for example in another select or a group transform. In this case, we evaluate and specify the columns that should be included in the output SQL.

Some examples:

prql target:sql.bigquery
from tracks
select ![milliseconds,bytes]

SELECT
  *
EXCEPT
  (milliseconds, bytes)
FROM
  tracks

from tracks
select [track_id, title, composer, bytes]
select ![title, composer]

SELECT
  track_id,
  bytes
FROM
  tracks

from artists
derive nick = name
select ![artists.*]

SELECT
  name AS nick
FROM
  artists

from e=employees
select e.first_name
filter e.first_name == "Fred" # Can't find `e.first_name`

from e=employees
select fname = e.first_name
filter fname == "Fred"

WITH table_1 AS (
  SELECT
    first_name AS fname
  FROM
    employees AS e
)
SELECT
  fname
FROM
  table_1 AS table_0
WHERE
  fname = 'Fred'