SQLAlchemy

Definitions

1. The most widely used Python SQL toolkit and ORM, providing both a low-level Core layer for composing SQL expressions as Python objects and a high-level ORM layer that maps Python classes to database tables. It supports multiple database backends (PostgreSQL, MySQL, SQLite, etc.) through a dialect system and emphasizes explicit, composable query construction over magic.

   In plain English: A popular Python library that lets you interact with databases either by writing Python code that generates SQL or by mapping database tables to Python objects.

   Example: "We use SQLAlchemy's ORM for the CRUD endpoints but drop down to Core for the complex reporting queries where we need full control over the SQL."

Related Terms

• ORM
• Migration
• CRUD
• Ecto
• N+1 Query Problem
• Jinja
• Kivy
• Query Builder
• Raw SQL
• TypeORM