"SELECT * FROM mytable WHERE column1='x' AND (column2='y' OR column3='z') works but
"SELECT * FROM mytable WHERE (column1='x' AND (column2='y' OR column3='z')) raises InvalidQueryException.
Sure, the outer parens around the where clause are extraneous, but the expression should still evaluate. I'm compiling where clauses from thousands of overlapping geographic features, and it is helpful as a default setting to enclose each sub-clause in parens, even if that means a lone feature ends up wrapped in these extraneous characters.
Happy to provide additional information/clarification if needed.
"SELECT * FROM mytable WHERE column1='x' AND (column2='y' OR column3='z')works but"SELECT * FROM mytable WHERE (column1='x' AND (column2='y' OR column3='z'))raisesInvalidQueryException.Sure, the outer parens around the where clause are extraneous, but the expression should still evaluate. I'm compiling where clauses from thousands of overlapping geographic features, and it is helpful as a default setting to enclose each sub-clause in parens, even if that means a lone feature ends up wrapped in these extraneous characters.
Happy to provide additional information/clarification if needed.