SELECT name AS n, CONCAT(name,'X') FROM mytab;

n     concat
------------
tim   timX
sue   sueX

When using the alias (n) in the projection it is not working.

SELECT name AS n, CONCAT(n,'X') FROM mytab;

> Unknown column 'n' in 'field list'

Is this generally not allowed or do I need to set it different to AS?

I have a longer statement and using alias in the projection would help.