In relational databases we have the recursive query do we have any feature to write any recursive queries on pinot tables? Example of one of the SQL recursive queries for relational database https://medium.com/swlh/recursion-in-sql-explained-graphically-679f6a0f143b

We are working on multi stage query engine that would be able to support this cc @Rong R

Are we supporting the recursive queries?

Nested queries? Yes