I have a table called STATUS that has a column named BUILD. The build column is integer and populated with values between and 1 and 6.
The following subquery in a NEW_QUERY_TABLE:
select build from
( select build from status
) subquery
returns the error 'Invalid column 'build' used in SELECT query.'
This is valid SQL that I have tested in PostgreSQL. Is this unsupported?