SQLObject
Appearance
SQLObject is a Python object-relational mapper between a SQL database and Python objects. It is currently experiencing community popularity, and forms a part of many applications (eg, TurboGears). It is very similar to Ruby On Rails' ActiveRecord in operation in that it uses class definitions to form table schemas, and utilitises the language's reflection and dynamism to be useful.
SQLObject supports a number of common database backends: included in the distribution are MySQL, PostgreSQL, SQLite, Sybase SQL Server, MaxDB, Microsoft SQL Server and Firebird.
External Links
SQLObject - The project's website