SQLAlchemy

The most widely used ORM for Python. It maps tables to classes and uses psycopg to talk to Postgres.