Schema Support

[waltaskew]

I'm interested in using SQLAlchemy to interact with Spanner, but my organization is planning to organize tables into schemas. It looks like the dialect doesn't currently support interacting with tables in schemas.

Is this something folks have plans to take on? I'd be happy to help, especially if folks could point me in the right direction or share thoughts they have about how to implement this.

[waltaskew]

Was actually able to make some progress on this today. Looks like the problem is that schema names aren't allowed in spots like SELECT bodies. Fortunately, there's an example in the mssql dialect which shows how to avoid them by aliasing the tables:

#639

https://github.com/sqlalchemy/sqlalchemy/blob/801e1e1982ebc5ecd8d77d46615311c6c7dc9b94/lib/sqlalchemy/dialects/mssql/base.py#L710