support more subqueries

[xudong963]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
support more subqueries and pass the TPCH associated with the subquery: https://github.com/apache/arrow-datafusion/issues?q=is%3Aopen+is%3Aissue+milestone%3ATPC-H

Describe the solution you'd like

• WHERE EXISTS (SELECT ...)
• SELECT (subquery) AS x or WHERE (subquery) = x
• [ NOT ] IN (SELECT ...) Implement physical plan for IN Subquery #1835
• <expr> <op> ANY/SOME (<query>)
• <expr> <op> ALL (<query>)
• Single-Row Comparison

Describe alternatives you've considered
Correlated subqueries will be implemented by nested loop initially. After the realization of basic functions, we can do some optimization, such as decorrelation and so on.

Additional context
Add any other context or screenshots about the feature request here.

[xudong963]

@houqp Please assign it to me, thanks!

[Igosuki]

Does that require to patch sqlparser or it's only on the engine side ?

[xudong963]

@Igosuki As far as know, sqlparser has supported subqueries that I listed, so it's only on the engine side.

[yahoNanJing]

Hi @xudong963, could you add #1835 to your list?

[xudong963]

Hi @xudong963, could you add #1835 to your list?

I think it has already had.

After #1649 is finished, the IN subquery can be easy to add.