Enable parsing of SQL query with where condition with multiples IN from oracle sintax

[renatobenks-zz]

How we could support this query? It's a new query sintax?

select fieldA from table where (fieldB, fieldC) in ((1 , 2))

[haskellcamargo]

The grammar for what you want is defined here.

InConditions

ExpressionList

So, you need to:

• Register the IN keyword here
• Create a new rule called ExpressionList where:

ExpressionList: [
  o 'Expression' -> [$1]
  o 'ExpressionList SEPARATOR Expression' -> new ExpressionList($1.concat($3))
  o 'LEFT_PAREN ExpressionList RIGHT_PAREN' -> $2
]

• Create rule InConditions according to the grammar, like I did for expressions
• Create AST nodes InConditions and ExpressionList
• Add InConditions rule as a possibility for WHERE clause
• Create string representation for the new AST nodes

Don't forget to write tests for it!