You can override this behavior with the .without_distinct() method on a query ... providing the object model for your databases. This decoupled architecture means SQLAlchemy can, in theory ...