Re: [sqlalchemy] SelectIn loader joining on parent table

2017-08-17 Thread Aidan Kane
Thanks for all the info Mike. I sort of figured that was the case as I started writing out my question — apologies for bothering you with it anyway! Awesome release, by the way. Loving all the new features. Thanks, as ever, for all your hard work. On Thursday, 17 August 2017 00:09:40 UTC+1, M

Re: [sqlalchemy] SelectIn loader joining on parent table

2017-08-16 Thread Mike Bayer
On Wed, Aug 16, 2017 at 7:48 AM, Aidan Kane wrote: > I'm sure there's a great reason for this, but why does the new selectin > loader join the parent table and use the parent ids instead of using the > foreign key directly on the child table? Is it just the complexity of > knowing what to filter f

[sqlalchemy] SelectIn loader joining on parent table

2017-08-16 Thread Aidan Kane
I'm sure there's a great reason for this, but why does the new selectin loader join the parent table and use the parent ids instead of using the foreign key directly on the child table? Is it just the complexity of knowing what to filter for / how to build the criteria for the selectin query?