Aliases with AS.

AS names an output column without changing the table. It is useful for reports and expressions. Requested output names are part of the result contract. Prefer lowercase names with underscores.

Small example:

SELECT city AS location FROM customers;