SQLAlchemy is a SQL toolkit and object relational mapper for Python. It encourages "relational mapping" as opposed to "table mapping" and includes enterprise-level features such as eager loading, unit-of-work object commits, topological dependency sorting, and full usage of bind parameters. It supports MySQL, Postgres, Oracle, and SQLite.
Release Notes: Dialect modules are now broken up into distinct subcomponents. The boolean value of Python boolean expressions now evaluates accurately with regards to the two clause objects being compared. The "executemany" behavior was improved. DDL functionality was expanded. The logging level of engines, pools, and mappers can be modified after creation. The Enum type was added.
Release Notes: This release adds a new level of functionality, including reworkings of almost every area, from more explicit contexual control of connections and sessions to polymorphic loading, new plugins, and improved APIs.
Release Notes: Improvements were made to Oracle support. A new engine capability was added, allowing nested transactions at the connection or unit-of-work level. Control of unit-of-work scoping was improved for individual objects. Many fixes and enhancements were made to table inheritance patterns. A new PickleType was added. Bugs in SQL construction were fixed. Mapping patterns were added.