Meaningful Column Aliases

meaningful_aliases.sql

-- avoid naming your CTEs this way

WITH cte AS (
  SELECT 1 AS a )
  ) ...


-- avoid inconsistent naming conventions

SELECT 'stationery' AS product_group, 'pen' AS ProductName


-- avoid non-meaningful aliases

SELECT 
  a, 
  b

FROM
  products t1 ON ....
JOIN
  prices t2 ON ....
JOIN
  orders t3 ON ....