Re: [sqlalchemy] Semi-Join to a UNION construct.

2018-02-12 Thread Mike Bayer
On Mon, Feb 12, 2018 at 11:38 AM, Christophe Biocca wrote: > Right, I can unpack the relationship between A and B into column expressions > manually, but this will break for `secondaryjoin` relationships. > I guess I can unpack those manually as well, by introducing the secondary > table expressio

Re: [sqlalchemy] Semi-Join to a UNION construct.

2018-02-12 Thread Christophe Biocca
Right, I can unpack the relationship between A and B into column expressions manually, but this will break for `secondaryjoin` relationships. I guess I can unpack those manually as well, by introducing the secondary table expression when needed. I will try that. On 12 February 2018 at 11:24, Mike

Re: [sqlalchemy] Semi-Join to a UNION construct.

2018-02-12 Thread Mike Bayer
On Sat, Feb 10, 2018 at 6:17 PM, Christophe Biocca wrote: > Let's say I have 2 models, A and B, with relationships A.bs (haslist=True) > and B.a (haslist=False) > > Doing a semi join is trivial: > > session.query(A).filter(A.bs.any(SomeConditionOnB)) > session.query(B).filter(B.a.has(SomeCondition