I think SQLAlchemy is the only ORM I've used that has support for most/all of: - Subqueries - HAVING clause - USE index hint - WHERE ... IN - SELECT DISTINCT

I think SQLAlchemy is the only ORM I've used that has support for most/all of: - Subqueries - HAVING clause - USE index hint - WHERE ... IN - SELECT DISTINCT - ON DUPLICATE KEY UPDATE - SELECT ... FOR UPDATE The trouble comes when you're using an ORM that has some but not all of the features, then the abstraction falls apart and you need to go down to using SQL anyway.