SQLAlchemy 2.1 Beta: t-string SQL and Free-threaded

Overview

SQLAlchemy 2.1b1, released on January 21, 2026, introduces t-string SQL, PEP-646 support and free-threaded mode.

Main Features

t-string SQL and PEP-646

t-strings allow building SQL queries safely with interpolation. PEP-646 (variadic generics) improves typing for multi-column queries.

from sqlalchemy import create_engine, text

engine = create_engine('sqlite:///:memory:')

with engine.connect() as conn:
    result = conn.execute(text('SELECT 1'))
    print(result.scalar())  # 1

Free-threaded mode

SQLAlchemy 2.1 is compatible with Python 3.14's free-threaded mode, enabling concurrent session access without the GIL.

Sources

• SQLAlchemy Changelog