Is the SQLAlchemy Core — SQL as Python lesson free?

Yes. The first 5 lessons on PyRun are free forever — no signup, no card. SQLAlchemy Core — SQL as Python runs real Python in your browser via Pyodide.

How long does the SQLAlchemy Core — SQL as Python lesson take?

About 15 minutes end-to-end. It's a hands-on lesson — you read a paragraph, edit the code, and run it in the same tab.

Do I need to install Python to try the SQLAlchemy Core — SQL as Python lesson?

No install required. PyRun runs real CPython in your browser via Pyodide (Python compiled to WebAssembly). Works on Chrome, Firefox, Safari, and Edge — desktop or mobile.

What level is the SQLAlchemy Core — SQL as Python lesson?

Advanced level. Assumes comfort with classes, functions, and standard library. Not for first-time Python learners.

← All lessons

Advanced·15 min·data · sqlalchemy · orm

SQLAlchemy Core — SQL as Python

SQLAlchemy Core: SQL, but as Python

Raw SQL strings are hard to compose and easy to get wrong. SQLAlchemy Core gives you an expression language — write queries as Python objects, get real SQL out.

Why bother

Type-checked in your editor — users.c.email == "..." is autocompleted.
Composable — filters, joins, aggregates are Python expressions you can build up conditionally.
Portable — same code runs against SQLite, Postgres, MySQL, MSSQL.
No injection — parameters are bound automatically.

Core primitives

create_engine("sqlite:///:memory:") — connection pool + dialect.
Table(name, MetaData(), Column(...)) — describe your schema.
select(t).where(...).order_by(...) — build a SELECT.
insert(t) / update(t) / delete(t) — the other DML verbs.
with engine.begin() as conn: — auto-commits on success, rolls back on exception.

When to use Core vs the ORM

Core: ETL, analytics, bulk operations, complex reporting queries.
ORM (next lesson): object-heavy business logic with rich relationships.
Both are the same library — you can mix them freely.

Try it

Add a query that counts users per plan.
Update Bob's plan to "pro" and re-run the select.

← PreviousSQL joins that actually make sense Next →SQLAlchemy ORM — objects that persist

← All lessons

Advanced·15 min·data · sqlalchemy · orm

SQLAlchemy Core — SQL as Python

SQLAlchemy Core: SQL, but as Python

Raw SQL strings are hard to compose and easy to get wrong. SQLAlchemy Core gives you an expression language — write queries as Python objects, get real SQL out.

Why bother

Type-checked in your editor — users.c.email == "..." is autocompleted.
Composable — filters, joins, aggregates are Python expressions you can build up conditionally.
Portable — same code runs against SQLite, Postgres, MySQL, MSSQL.
No injection — parameters are bound automatically.

Core primitives

create_engine("sqlite:///:memory:") — connection pool + dialect.
Table(name, MetaData(), Column(...)) — describe your schema.
select(t).where(...).order_by(...) — build a SELECT.
insert(t) / update(t) / delete(t) — the other DML verbs.
with engine.begin() as conn: — auto-commits on success, rolls back on exception.

When to use Core vs the ORM

Core: ETL, analytics, bulk operations, complex reporting queries.
ORM (next lesson): object-heavy business logic with rich relationships.
Both are the same library — you can mix them freely.

Try it

Add a query that counts users per plan.
Update Bob's plan to "pro" and re-run the select.

← PreviousSQL joins that actually make sense Next →SQLAlchemy ORM — objects that persist