Object-Relational Mapping API for Python

[Aquarius]

I explored Java's Hibernate a bit and I was intrigued by how you can
map entity objects to database tables, preserving all the relations and
constraits. I am interested if there is something like this for Python
- I noticed some APIs in the "Cheeseshop", but most of them were alpha,
better, or seemed to be forsaken a long time ago. Can you recommend me
anything?