Using VolcanoPlanner to create unified RelNode tree from multiple SQL

[Chinmay Kolhatkar]

Dear Community,

I'm working on integration with Apache Apex and Apache Calcite (underlying
Apache Jira is: APEXMALHAR-1818).

I have a question related to conversion from SQL to RelNode Tree.

Is it possible that VolcanoPlanner can take multiple SQL statements as
input and return a unified RelNode Tree?
Example of above is as follows:

SELECT COL1, COL2 FROM TABLE WHERE COL3 > 10;
SELECT COL1, COL2 FROM TABLE WHERE COL4  = 'abc';

Above 2 statements has a common path and hence can provide an unified
RelNode tree as follows:

 [Scan] -> [Project (COL1, COL2)] -> [Filter (COL4 = 'abc')] -> [Delta]
                    |
                    V
            [Filter (COL3 > 10)]
                    |
                    v
                 [Delta]


Thanks,
Chinmay.