SQLModel is a Python library for interacting with SQL databases using Python objects. It is designed to be simple and robust, built on top of Pydantic and SQLAlchemy, with compatibility intended for FastAPI. Useful for defining SQL table-like models with type annotations and performing CRUD operations while keeping code concise and editor-friendly.
Project status
- Actively maintained: The repository shows recent activity in 2026, with an upstream push on 2026-07-13, and multiple version bumps (0.0.37 to 0.0.39) within the year.
- Apparent update cadence: Updates appear to land roughly every 6 to 8 weeks (0.0.37 on 2026-02-21, 0.0.38 on 2026-04-02, 0.0.39 on 2026-06-25). This suggests an ongoing, non-stalled development stream.
AI summary generated
Recent updates
0.0.39
Release 0.0.39 has no publisher-provided release notes. The provided diff content shows primarily documentation and GitHub automation/workflow changes, with no obvious runtime library API changes in the excerpts shown.
0.0.38
Release 0.0.38 primarily contains typing annotation fixes for `SQLModel.__new__` and `tuple_`, plus documentation updates including a new tutorial snippet for the `.in_()` expression helper. It also includes several internal build and dependency management updates. The library runtime behavior appears unchanged in the diff shown, with most changes focused on docs, CI, and typing.
0.0.37
Release 0.0.37 is a small internal update focused on CI publishing behavior. It also bumps the library version to 0.0.37 and updates the project release notes document to include this internal note.
0.0.36
Release 0.0.36 primarily removes support for the `sqlmodel-slim` distribution variant. The package version is bumped to 0.0.36, and internal build configuration and tooling for `sqlmodel-slim` is deleted.
Breaking0.0.35
Release 0.0.35 primarily drops Python 3.9 support and includes internal maintenance to remove Python 3.9 specific files, alongside small tooling dependency bumps. The provided code diff shows a large deletion of docs and tutorial example code under paths ending with _py39, with no visible runtime/library API changes in the shown diff.
Breaking0.0.34
Release 0.0.34 is labeled as an internal-only update, focusing on CI test matrix adjustments and dependency version bumps. The repo updates tooling (ruff, typer) and FastAPI, and changes how the CI environment installs dependencies across “lowest” and “highest” resolution scenarios.
0.0.33
Release 0.0.33 is primarily documentation and internal maintenance. It bumps several tooling and framework dependencies, updates build configuration related to `sqlmodel-slim`, and adjusts async session docstring examples. The code diff also shows changes to CI/build hooks and test assertions for FastAPI `ValidationError` schema variations.
0.0.32
Release 0.0.32 includes a fix for SQLModel support of Pydantic 2.12+ when using Annotated fields, plus a small refactor to import Literal directly from typing. The diff also shows broad internal maintenance, including dependency bumps and a migration to uv for installation and build steps.
0.0.31
v0.0.31 drops Pydantic v1 support and refactors the internal Pydantic compatibility layer to assume Pydantic v2 behavior. The release also updates documentation tooling and several development dependencies.
Breaking0.0.30
Release 0.0.30 formally drops support for Python 3.8, updating CI and documentation accordingly. The release also updates internal development tooling, including pre-commit configuration and GitHub Actions versions, and significantly refactors documentation source example files to use newer Python-specific variants.
Breaking0.0.29
Release 0.0.29 adds Pydantic v2 alias support improvements and updates the Field helper so it can handle validation_alias and serialization_alias. The release notes only mention the alias support fix, but the code diff shows additional API surface area and changed runtime behavior, especially around Pydantic v1 error handling.