This request does not work. Why?
Select id,name_column as name from test_table where name='test'
Throws an "invalid identifier" error. those. if the request is of the form:
Select id,(select count(*) from test_table)as tmp_col from test_table where tmp_col>1
then it will not work either. How to win?