[sqlalchemy] [Q][SA 07.9] - Trouble with EXISTS that references main SELECT

Hello. The following SA code: # cls = Advice q0 = session.query(Deal).join(ImportedPartnerShare).filter( Deal.main_deal_ext_id == cls.main_deal_ext_id, ImportedPartnerShare.partner_id == partner.id, ) q = session.query(cls).filter(exists(q0.with_entities('1').statement)) q = q.options(

Re: [sqlalchemy] [Q][SA 07.9] - Trouble with EXISTS that references main SELECT

Hello. I have found a solution to my problem: correlate(). The following code produces SQL I want (see below): q0 = session.query(Deal).join(ImportedPartnerShare).filter( Deal.main_deal_ext_id == cls.main_deal_ext_id, ImportedPartnerShare.partner_id == partner.id,