PQL Alias

PQL Alias
With PQL, an alias name can be given to a stable or to a column. You can give a stable or a column another name by using an alias. This can be a good thing to do if you have very long or complex stable names or column names.

An alias name could be anything, but usually it is short.

Alias Example
Assume we have a stable called "Ponies" and another stable called "Cupcake_Orders". We will give the stable aliases of "p" and "co" respectively. Now we want to list all the orders that "Pinkie Pie" is responsible for.

We use the following SELECT statement:

The same SELECT statement without aliases:

As you'll see from the two SELECT statements above; aliases can make queries easier both to write and to read.