The CZQL query parser does not correctly determine whether a token is an identifier or a keyword when the entity being SELECTed contains a field with a matching name.
Unfortunately, CZQL does not appear to support a syntax that allows identifiers to be delimited, which would let developers correct the ambiguity on their own. (This is what every SQL flavour does.)
All of the following queries should either run successfully, or all should result in a syntax error; however, that's not what happens:
SELECT Name, Order FROM ProjectType
Actual result: fails
SELECT Order, Name FROM ProjectType
Actual result: succeeds (!)
SELECT Order, Name FROM ProjectType ORDER BY Order ASC
Actual result: fails
Please either change the parser to correctly identify the intended context, or add a syntax element, such as square brackets, that allows developers to delimit identifiers themselves.