WITH demo AS (
  SELECT * FROM (VALUES
    (1, 'Alice'),
    (2, 'Bob'),
    (3, 'Charlie')
  ) AS t(id, name)
)
SELECT id, name, LENGTH(name) AS name_len
FROM demo
ORDER BY id;