[sqlalchemy] Re: Join on filter for chained loads

2018-01-07 Thread Erol Merdanović
Hello Jonathan Yes, I was suspecting that aliased was the solution but wasn't sure if it's the correct approach. It works, thank you for your help! On Saturday, 6 January 2018 18:52:54 UTC+1, Jonathan Vanasco wrote: > > use `sqlalchemy.orm.aliased` to create an alias of A for your join >

[sqlalchemy] Re: Join on filter for chained loads

2018-01-06 Thread Jonathan Vanasco
use `sqlalchemy.orm.aliased` to create an alias of A for your join condition... A_alt = sqlalchemy.orm.aliased(A, name='a_alt') then use that to join and specify your join conditions the `contains_eager` needs to specify the alias though.