I'm curious if anyone has any thoughts on how to go about implementing recursive queries. Postgres seems to only allow recursive queries with the form "non-recursive-term UNION [ALL] recursive-term" and uses a separate "recursive union" operator.
Costing is also certainly a challenge since there's no obvious way to know how many times the recursive query will need to run. Specific suggestions would probably be best placed on the corresponding issue. Thanks! https://issues.apache.org/jira/browse/CALCITE-129 -- Michael Mior [email protected]
