Allow for selection of schema dynamically at query time

[robot-head]

We have a multi-tenant application we are working on, and we'd like to select the postgres schema to execute our queries against at runtime.

It seems that the schema_name can be configured as part of an Entity trait implementation, but we were hoping this could be supplied optionally to the query methods: https://docs.rs/sea-orm/latest/sea_orm/entity/trait.EntityName.html#method.schema_name

[tyt2y3]

I think the easiest way is actually leaving the fn schema method None, but specifying the schema in the connection string with currentSchema?

[robot-head]

The problem with that is we would need to maintain a connection pool per tenant, and we'd like to support upwards of 50 tenants. We will be using the same user for all schemas, we just want to switch the schema at runtime without instantiating a new connection pool