[Sqlalchemy-tickets] Issue #4127: Allowing schema name to be specified for table construction (zzzeek/sqlalchemy)

[Philip M. <iss...@bi...>]

New issue 4127: Allowing schema name to be specified for table construction
https://bitbucket.org/zzzeek/sqlalchemy/issues/4127/allowing-schema-name-to-be-specified-for

Philip Martin:

I want to propose a change to the table expression class so it can accept a schema name in its constructor. I believe this is useful when building queries that are referencing table objects with different schema names. My proposed enhancement would follow the same convention used in the Table class by allowing for:

```python
from sqlalchemy import column, table, MetaData, Table, Column, CHAR

# this currently generates a TypeError due to invalid keyword argument
t = table('bar', column('x'), schema='foo')

# same API as Table class
t = Table('bar', MetaData(), Column('x', CHAR(2), primary_key=True), schema='foo)
```