Multi tenancy/Using multiple schemas

[windowsdeveloperwannabe]

Hello 🙂
Has anyone figured a way to do multi tenancy in SQLx yet?

Is there a way to SET search_path TO {customer} before a query or FROM {customer}.tablename in the query itself? Or would you create a database connection per customer using ?search_path={customer} in database url and hold them in a map like HashMap<Customer, PgPool>?

Interesting approaches in Rails and Elixir:
https://hexdocs.pm/ecto/multi-tenancy-with-query-prefixes.html
https://github.com/rails-on-services/apartment