Use Alias Names in Other Clauses
The alias name for a column is defined in the Select clause. You cannot use this alias to refer to that column in any RAQL clauses, including expressions for later columns within Select, with the exception of the Order By clause. These RAQL queries, for example, will result in an error:
select Id, Descr, decimal(Qty) as Quantity from items where Quantity > 5
select Id, Descr, decimal(Qty) as Quantity, (Quantity / 1000) as PerMille from items
However, this query is valid:
select Id, Descr, decimal(Qty) as Quantity from items order by Id, Quantity
There are two techniques you can use rather than using an alias. You can duplicate the original column, such as this example:
select Id, Descr, decimal(Qty) as Quantity from items where decimal(Qty) > 5
This can be cumbersome or in some cases impossible where the syntax is complex. Another solution is to define the alias in a subquery so that you can refer to it in an outer query. For an example of this syntax, see
From Subqueries.