> Imagine if someone (or company) starts a comparable open-source translation extension layer targeting Postgres as the backend

That's what Babelfish is.