from sqlalchemy import desc someselect.order_by(desc(table1.mycol))
query = sqlalchemy.select([film]).order_by(sqlalchemy.asc(film.columns.replacement_cost))