SQLAlchemy is pretty much the only ORM I've used that DIDN'T suck. It's great, especially after seeing Java / Hibernate hell.