Does Dremio support SP/Functions ? Does it have any plan to ? What about CTE (ex: RECURSIVE) ?
@vrb When you say CTE (Recursive), I assume you are taking about SQL using the WITH clause? This is certainly supported.
Currently stored procedures are not supported, however you can call stored procedures of RDBMS like Oracle using External query option
https://docs.dremio.com/software/data-sources/external-queries/
Thank you. I know the WITH clause is supported. But there is a WITH RECURSIVE clause (PostgreSQL: Documentation: 14: 7.8. WITH Queries (Common Table Expressions)) . Is it supported in Dremio ?
@vrb Not at the moment, have you tried using it with external queries if it has to be sent to Postgres?
https://docs.dremio.com/software/data-sources/external-queries/