Sorry, I missed an example in my first message. The problem arises
when you try to query across two databases:
Session.query(MainUser).join((OtherUser, OtherUser.id == MainUser.id))
Would normally products something like:
SELECT * FROM MainUser INNER JOIN OtherUser ON OtherUser.id =
Aculeus wrote:
Sorry, I missed an example in my first message. The problem arises
when you try to query across two databases:
Session.query(MainUser).join((OtherUser, OtherUser.id == MainUser.id))
Would normally products something like:
SELECT * FROM MainUser INNER JOIN OtherUser ON
Aculeus wrote:
This has a severe problem having to hard set the schema when that
value should be part of configuration. Instead the table should assume
the schema of the engine that it's metadata is bound to and
automatically appear in queries where there is a table from a
different schema
