Re: [sqlalchemy] Change a select clause + add a join automatically

Thank you! It is indeed a query-interception requirement, so that looks appropriate. I will have a deeper look on how it can be used. Rgds On Thu, Apr 20, 2023, 3:08 PM Simon King wrote: > I think this is the intended use for the do_orm_execute event and the > with_loader_criteria query

Re: [sqlalchemy] Change a select clause + add a join automatically

I think this is the intended use for the do_orm_execute event and the with_loader_criteria query option: https://docs.sqlalchemy.org/en/14/orm/session_events.html#do-orm-execute-global-criteria https://docs.sqlalchemy.org/en/14/orm/query.html#sqlalchemy.orm.with_loader_criteria You ought to be