title: SQLAlchemy support of Postgres Schemas
body: <p>We host a multitenant app with SQLAlchemy and postgres. I am looking at moving from having separate databases for each tenant to a single database with multiple schemas. Does SQLAlchemy support this natively? I basically just want every query that comes out to be prefixed with a predetermined schema... e.g</p>
  
  <pre><code>select * from client1.users
  </code></pre>
  
  <p>instead of just </p>
  
  <pre><code>select * from users
  </code></pre>
  
  <p>Note that I want to switch the schema for all tables in a particular request/set of requests, not just a single table here and there.</p>
  
  <p>I imagine that this could be accomplished with a custom query class as well but I can't imagine that something hasn't been done in this vein already.</p>