That is standard view expansion. We support this. Julian
> On Aug 16, 2019, at 06:12, Leon Xu <[email protected]> wrote: > > Hi Calcite devs, > > We are modeling a usecase using a DAG. Each node in the DAG will be some > select query. We would like to use calcite to convert all these queries > into one consolidated query. > e.g. > In node1, we have query: `select a from node2;` > In node2, we have query: `select a, b from foo;` > > should be converted to `select a from (select a, b from foo);` > > If we were to use calcite to achieve this, what would be the best > implementation? Should I extend a substituionVisitor and replace table name > with the correspoinding query? > > Thanks
