The SQLAlchemy SQL Toolkit and Object Relational Mapper a comprehensive set of tools for working with databases and Python. It has several distinct areas of which can be used individually or combined together. Its major components are illustrated below, component dependencies organized into layers:
The documentation is separated into three sections: SQLAlchemy ORM, SQLAlchemy Core, and Dialects.
In SQLAlchemy ORM, the Object Relational Mapper is introduced and fully described. New users should begin with the Object Relational Tutorial. If you want to work with higher-level SQL which is constructed automatically for you, as well as management of Python objects, proceed to this tutorial.
In SQLAlchemy Core, the breadth of SQLAlchemy’s SQL and database and description services are documented, the core of which is the Expression language. The SQL Expression Language is a toolkit all its own, of the ORM package, which can be used to construct manipulable SQL which can be programmatically constructed, modified, and executed, cursor-like result sets. In contrast to the ORM’s domain-centric mode of usage, the expression language provides a schema-centric usage . New users should begin here with SQL Expression Language Tutorial.