Hacker News new | ask | show | jobs
by teslatom 824 days ago
I've been looking for a library that can convert query plans, not just ASTs, between Postgres and other query engines. The reason this is useful is because RLS (row level security) settings are injected into the query plan after the AST is constructed, so the same query string can produce different query plans depending on the security settings of the database.

Substrait comes close, but I haven't found a Postgres Substrait producer. Are there any projects working on this?