I've always hated other people's ORMs because they tended to restrict what I could do more then they helped me. However, I love SQLAlchemy. It is complex, and

I've always hated other people's ORMs because they tended to restrict what I could do more then they helped me. However, I love SQLAlchemy. It is complex, and has a bit of a steep learning curve, but it is very very flexible. Nearly everything you can do in SQL, the most complex queries, you can do in SQLAlchemy. But without writing actual SQL. Composing queries using Python expressions is simply great.