Comment by Simpliplant

You can already do that with pgcat (author’s second project) https://github.com/postgresml/pgcat