Where can you use such an alias sql? code example

Example: sql as

SELECT CustomerID AS ID, CustomerName AS Customer