Re: [sqlalchemy] Trying to find a way to sort a query given the name of one of its columns

2023-06-10 Thread Mike Bayer
it looks like you're trying to add an ORDER BY to the table that's only there via joinedload().That's *really* not something we anticipate and it would be better if people proposed perhaps ad-hoc order_by expressions to be added to common loader options like joinedload() and selectinload(),

[sqlalchemy] Trying to find a way to sort a query given the name of one of its columns

2023-06-10 Thread Lele Gaifax
Hi, I spent some more time to improve support for SA 2 of one of my SA-based libraries[1] (the most ancient one, born with SA 0.5, fifteen years ago!): its goal is to provide a layer that made it easier to "expose" a SA query (either an ORM one or a Core select()) thru a web service, handling