[Python] How do I pass a variable in to the order_by clause in sqlalchemy?

Let's say I have a basic table like so:

id: Mapped[int] = mapped_column(primary_key=True)

name: Mapped[str] = mapped_column(String(30))


How can I pass a variable in to my Select statement so I can decide what to order by at runtime?

That is, I can have a call like this:

db.session.scalars(select(OrgModel).order_by(OrgModel.id.desc()).all()


but I can't have

order_field = 'name'

db.session.scalars(select(OrgModel).order_by(order_field).all()


How do you accomplish this?

Continue reading...