# SQLAlchemy

*noun*

say it: **“ESS-kyoo-el AL-kuh-mee”** **/ˌɛs kju ˈɛl ˈælkəmi/**

Python's most used ORM and database toolkit: tables are described as classes, and queries built in Python are turned into SQL.

## What is **SQLAlchemy**?

**SQLAlchemy** is Python's most used ORM and database toolkit. Each table is a class, and a query such as
`select(Workout).where(Workout.member == "Luis")` is built in Python and turned into SQL with a placeholder.
SQLModel builds on it.

```python
from sqlalchemy import create_engine, select
from sqlalchemy.orm import DeclarativeBase, Mapped, Session, mapped_column

class Base(DeclarativeBase):
    pass

class Workout(Base):
    __tablename__ = "workouts"
    id: Mapped[int] = mapped_column(primary_key=True)
    member: Mapped[str]
    minutes: Mapped[int]

engine = create_engine("sqlite://")   # a database in memory
Base.metadata.create_all(engine)      # writes CREATE TABLE workouts for you
with Session(engine) as session:
    session.add_all([Workout(member="Luis", minutes=40), Workout(member="Ana", minutes=25)])
    session.commit()
    for workout in session.scalars(select(Workout).where(Workout.member == "Luis")):
        print(workout.member, workout.minutes)   # Luis 40
```

## In a sentence

- “The workout API on GitHub used **SQLAlchemy**, so its query read select(Workout).where(Workout.member == "Luis").”
- “SQLModel builds on **SQLAlchemy** and Pydantic.”

Level: Freelancer · [More Python terms at this level](https://www.ask-codey.com/glossary?category=python&level=4)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/sqlalchemy
