I've added NORM to GitHub; it's a python object-table mapper that I've been using for a few years.
It aims to make simple CRUD operations simple, and allow you to drop down to SQL when the complicated fun stuff needs to happen. Using it is somewhat similar to ActiveRecord or maybe Doctrine, but without attempting to rather terribly abstract SQL into functions and objects.
It's at http://github.com/dantheta/norm
I also aim to extend it with a model generator at some point in the near future.