Is it possible to generate a strategy for Oracle?

[gansai]

As I have seen, your code uses CTE and this strategy can be used for Postgres.
But, can we make a generic strategy, which, is irrespective of whichever database, it can ultimately avoid creating temporary tables.

As, I am facing some permission issue with Oracle and not able to create temporary tables.

[epiresdasilva]

Of course, yes. I think it's a very good idea. Can you contribute with this development?

[gansai]

would love to. I shall update you once I come up with some design/idea on how to solve this.