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.2.
License: GNU Lesser General Public License (LGPL)
Changes:
SQLObject now requires Python 2.3.
SQLObject.select() (i.e., SelectResults) and
DBConnection.queryForSelect() use SQLBuilder
Select queries. This means that all SELECTs are
implemented internally via a single mechanism that
supports all options. SQLBuilder ImportProxy was
added, which allows one to ignore the circular
import issues. SelectResults.throughTo was added,
which allows one to traverse Joins via SQL,
avoiding the intermediate objects. ViewSQLObject
was added. MySQLConnection (and DB URI) accept a
number of SSL-related parameters.