An API to all SQL features isn't something I want to see in an ORM. I'd rather keep things simple and leave count, sum, etc. as functions you're welcome to drop down to a raw cursor to access.
SQLAlchemy may well come the closest to "feature complete, but no more" of all the Python ORM projects. The "Unit of work" concept and others show a level of sophistication not seen in the "I just want to use my database as an object store" tools. Don't pollute it with a swiss army knife of seldom-used features. :)
--
Jonathan Ellis
http://spyced.blogspot.com
- [Sqlalchemy-users] Re: Is there a count() method? Jonathan Ellis
- Re: [Sqlalchemy-users] Re: Is there a count() method? Michael Bayer

