SQLCrucible

Get the full power of Pydantic for your API and the full power of SQLAlchemy for your database, without compromising on either.

SQLCrucible lets you define a single model class that works as both a Pydantic model and a SQLAlchemy table, with explicit conversion between the two. Your Pydantic models stay pure Pydantic (working with FastAPI, validation, serialization), your SQLAlchemy models stay pure SQLAlchemy (supporting relationships, inheritance, Alembic), and conversion only happens when you ask for it.

Key Features

Explicit conversion — to_sa_model() and from_sa_model() make it clear when you're crossing the boundary between Pydantic and SQLAlchemy
Native SQLAlchemy — use mapped_column(), relationship(), and __mapper_args__ directly; if SQLAlchemy supports it, so does SQLCrucible
Escape hatches everywhere — mix with plain SQLAlchemy models, attach entities to existing tables, customize generated models, or drop down to raw queries
Full inheritance support — single table, joined table, and concrete table inheritance all work out of the box
Type stub generation — generate .pyi stubs for IDE autocompletion and type checking of SQLAlchemy columns
Multiple frameworks — works with Pydantic, dataclasses, and attrs

Example

from typing import Annotated
from uuid import UUID, uuid4

from pydantic import Field
from sqlalchemy import create_engine, select
from sqlalchemy.orm import Session, mapped_column

from sqlcrucible import SAType, SQLCrucibleBaseModel

class Artist(SQLCrucibleBaseModel):
    __sqlalchemy_params__ = {"__tablename__": "artist"}

    id: Annotated[UUID, mapped_column(primary_key=True)] = Field(default_factory=uuid4)
    name: str

engine = create_engine("sqlite:///:memory:")
SAType[Artist].__table__.metadata.create_all(engine)

artist = Artist(name="Bob Dylan")
with Session(engine) as session:
    session.add(artist.to_sa_model())
    session.commit()

with Session(engine) as session:
    sa_artist = session.scalar(
        select(SAType[Artist]).where(SAType[Artist].name == "Bob Dylan")
    )
    artist = Artist.from_sa_model(sa_artist)

Installation

pip install sqlcrucible

Documentation

Full documentation is available at sqlcrucible.rdrj.uk.

🏴󠁧󠁢󠁳󠁣󠁴󠁿 Made with haggis

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlcrucible-0.5.1.tar.gz (166.6 kB view details)

Uploaded Aug 1, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

sqlcrucible-0.5.1-py3-none-any.whl (56.8 kB view details)

Uploaded Aug 1, 2026 Python 3

File details

Details for the file sqlcrucible-0.5.1.tar.gz.

File metadata

Download URL: sqlcrucible-0.5.1.tar.gz
Upload date: Aug 1, 2026
Size: 166.6 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for sqlcrucible-0.5.1.tar.gz
Algorithm	Hash digest
SHA256	`66df805774fc31a4e3cade65a760eec9926ee1d0cef15852db31e1d8d3158a1b`
MD5	`b1c466c5748ea7aeadb220ad4cf11776`
BLAKE2b-256	`f82cca75d61c8eef5d089c79341b03e8fcbdc0117f79ca8fb776c3dea21ba014`

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlcrucible-0.5.1.tar.gz:

Publisher: ci.yml on RichardDRJ/sqlcrucible

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: sqlcrucible-0.5.1.tar.gz
- Subject digest: 66df805774fc31a4e3cade65a760eec9926ee1d0cef15852db31e1d8d3158a1b
- Sigstore transparency entry: 2310461482
- Sigstore integration time: Aug 1, 2026
Source repository:
- Permalink: RichardDRJ/sqlcrucible@b598f4d033b80dd61296ab40edf30b77abd8d94f
- Branch / Tag: refs/tags/0.5.1
- Owner: https://github.com/RichardDRJ
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: ci.yml@b598f4d033b80dd61296ab40edf30b77abd8d94f
- Trigger Event: push