The parser does not support parenthesis after USING clause

[radegran]

The parser does not accept left parenthesis after USING clause. The generative AI model I use for generating SQL queries keeps adding parentheses.

Example:

SELECT * FROM ? a JOIN ? b USING (c)

SyntaxError: Parse error on line 1:
... ? a JOIN ? b USING (c)
-----------------------^
Expecting 'LITERAL', 'BRALITERAL', got 'LPAR'

This fiddle shows the details.

[paulrutter]

I recently proposed changes to the parser, see #1982. This shows it's probably not hard to support parentheses as well.

Probably here:

alasql/src/alasqlparser.jison

Line 2750 in 30813b9

: USING FromTable

Add another case including LPAR and RPAR.

[mathiasrw]

Released as part of v4.6.1