SQLAlchemy is most famous for its object-relational mapper (ORM), an optionalĬomponent that provides the data mapper pattern, whereĬlasses can be mapped to the database in open ended, multiple ways -Īllowing the object model and database schema to develop in a cleanly Language builds on this concept from its core. Units can be composed into a larger structure. Tables but also joins and other select statements any of these SQLAlchemy considers the database to be a relational algebra engine, Tables and rows the more abstraction starts to matter. Size and performance start to matter object collections behave less like SQL databases behave less like object collections the more Into a simple and Pythonic domain language. Patterns, designed for efficient and high-performing database access, adapted It provides a full suite of well known enterprise-level persistence Gives application developers the full power and flexibility of SQL. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that The Python SQL Toolkit and Object Relational Mapper
