Re: [sqlalchemy] subquery relationships?

2023-05-31 Thread Mike Bayer
docs for this are at: https://docs.sqlalchemy.org/en/20/orm/join_conditions.html there are several approaches to relationships with subqueries, the most open ended is the one described at https://docs.sqlalchemy.org/en/20/orm/join_conditions.html#relationship-to-aliased-class On Wed, May

[sqlalchemy] subquery relationships?

2023-05-31 Thread Dan Stromberg
Hi folks. I have a subquery that is selected from a table with 5 foreign keys, and joined with another table with 3 foreign keys. And then that subquery is used in a join with the table having the 3 foreign keys again. I don't know how to tell what column(s) that join is happening on. What