v3.1.0 - SQLAlchemy-style ORDER BY

Breaking Changes

The tuple-based ORDER BY syntax has been removed in favor of cleaner .asc() and .desc() methods.

Migration Guide

Old syntax (removed):

Users.select().order_by((Users.id, 'DESC'))
Users.select().order_by(Users.username, (Users.id, 'DESC'))

New syntax:

Users.select().order_by(Users.id.desc())
Users.select().order_by(Users.username, Users.id.desc())
Users.select().order_by(Users.username.asc(), Users.id.desc())

New Features

• Added Column.asc() method for explicit ascending order
• Added Column.desc() method for descending order
• More ergonomic and Pythonic API inspired by SQLAlchemy