I have a relationship from "foo" to "boo", and the latter inherits from "bar":
class boo(bar): ...
In the following, SQLAlchemy generates (1), but I would like it to generate (2)
because this helps PostgreSQL come up with an optimal query plan:
-- Query 1:
SELECT * FROM foo JOIN (bar JOIN boo ON bar.id = boo.id) ON foo.id = boo.id;
-- Query 2:
SELECT * FROM foo JOIN boo ON foo.id = boo.id JOIN bar ON bar.id = boo.id;
What needs to be implemented to support such a "flat" relationship join
configuration?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
