Modeling Framework fills the gap between the Python object world and relational databases in that it allows users to transparently create, retrieve, update, or delete Python objects from a database without having to write a single line of SQL. Its main features include generation of database schema, generation of Python code templates ready to be used, support for transparent mapping of (class) inheritance in relational databases, object-oriented query language, use of standard Python getters to traverse relationships (the related objects are automatically fetched when needed and when appropriate), and automatic checking for referential-integrity constraints, etc. Supported databases are MySQL, Oracle, PostgreSQL, and SQLite.
SQLObject is an object-relational mapper, i.e., a library that will wrap your database tables in Python classes and your rows in Python instances. It currently supports MySQL through the 'MySQLdb' package, PostgreSQL through the 'psycopg' package, SQLite, Firebird, MaxDB (SAP DB), MS SQL, and Sybase. It should support Python versions back to 2.4.