Grammar ambiguities around `{LEFT|RIGHT} [OUTER] JOIN`

[RobertBrunel]

The LEFT and RIGHT tokens are currently accepted as “simple identifiers” (simpleId). This causes ANTLR’s adaptive LL(*) parsing algorithm to flag certain {LEFT|RIGHT} OUTER JOIN queries as ambiguous and raise a parser error under debugBuild=true.