Pydantic-SQLAlchemy

Tools to generate Pydantic models from SQLAlchemy models.

Still experimental.

🚨 WARNING: Use SQLModel instead 🚨

SQLModel is a library that solves the same problem as this one, but in a much better way, also solving several other problems at the same time.

This project was to solve some simple use cases, to generate dynamic Pydantic models from SQLAlchemy models. But the result cannot be used very well in code as it doesn't have all the autocompletion and inline errors that a Pydantic model would have.

This was a very simple implementation, SQLModel is a much better solution, much better design and work behind it.

For most of the cases where you would use pydantic-sqlalchemy, you should use SQLModel instead.

How to use

Quick example:

from typing import List

from pydantic_sqlalchemy import sqlalchemy_to_pydantic
from sqlalchemy import Column, ForeignKey, Integer, String, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import Session, relationship, sessionmaker

Base = declarative_base()

engine = create_engine("sqlite://", echo=True)


class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)
    nickname = Column(String)

    addresses = relationship(
        "Address", back_populates="user", cascade="all, delete, delete-orphan"
    )


class Address(Base):
    __tablename__ = "addresses"
    id = Column(Integer, primary_key=True)
    email_address = Column(String, nullable=False)
    user_id = Column(Integer, ForeignKey("users.id"))

    user = relationship("User", back_populates="addresses")


PydanticUser = sqlalchemy_to_pydantic(User)
PydanticAddress = sqlalchemy_to_pydantic(Address)


class PydanticUserWithAddresses(PydanticUser):
    addresses: List[PydanticAddress] = []


Base.metadata.create_all(engine)


LocalSession = sessionmaker(bind=engine)

db: Session = LocalSession()

ed_user = User(name="ed", fullname="Ed Jones", nickname="edsnickname")

address = Address(email_address="ed@example.com")
address2 = Address(email_address="eddy@example.com")
ed_user.addresses = [address, address2]
db.add(ed_user)
db.commit()


def test_pydantic_sqlalchemy():
    user = db.query(User).first()
    pydantic_user = PydanticUser.from_orm(user)
    data = pydantic_user.dict()
    assert data == {
        "fullname": "Ed Jones",
        "id": 1,
        "name": "ed",
        "nickname": "edsnickname",
    }
    pydantic_user_with_addresses = PydanticUserWithAddresses.from_orm(user)
    data = pydantic_user_with_addresses.dict()
    assert data == {
        "fullname": "Ed Jones",
        "id": 1,
        "name": "ed",
        "nickname": "edsnickname",
        "addresses": [
            {"email_address": "ed@example.com", "id": 1, "user_id": 1},
            {"email_address": "eddy@example.com", "id": 2, "user_id": 1},
        ],
    }

Release Notes

Latest Changes

0.0.10

Breaking Changes

• ➖ Drop support for End of Life Python versions 3.8 and 3.9. PR #240 by @tiangolo.

Docs

• 📝 Add SQLModel docs. PR #70 by @tiangolo.

Internal

• 👷 Update Dependabot. PR #239 by @tiangolo.
• 👷 Update Dependabot. PR #238 by @tiangolo.
• Dependabot: remove pip-level label assignment from grouped updates. PR #234 by @Copilot.
• 👷 Upgrade actions/checkout from v5 to v6. PR #225 by @tiangolo.
• 👷 Upgrade latest-changes GitHub Action and pin actions/checkout@v5. PR #224 by @tiangolo.
• ⬆ Bump actions/labeler from 5 to 6. PR #208 by @dependabot[bot].
• ⬆ Bump actions/download-artifact from 4 to 6. PR #219 by @dependabot[bot].
• ⬆ Bump pypa/gh-action-pypi-publish from 1.12.4 to 1.13.0. PR #207 by @dependabot[bot].
• ⬆ Bump actions/checkout from 4 to 5. PR #202 by @dependabot[bot].
• ⬆ Bump tiangolo/latest-changes from 0.3.2 to 0.4.0. PR #198 by @dependabot[bot].
• ⬆ Bump typing-extensions from 4.6.1 to 4.13.2. PR #173 by @dependabot[bot].
• ⬆ Bump astral-sh/setup-uv from 5 to 6. PR #176 by @dependabot[bot].
• ⬆ Bump ruff from 0.9.8 to 0.11.13. PR #182 by @dependabot[bot].
• Enable CI for Python 3.9 - 3.13. af66239 by @tiangolo.
• ⬆ Bump ruff from 0.7.1 to 0.9.8. PR #156 by @dependabot[bot].
• ⬆ Bump astral-sh/setup-uv from 3 to 5. PR #144 by @dependabot[bot].
• ⬆ Bump pypa/gh-action-pypi-publish from 1.11.0 to 1.12.4. PR #151 by @dependabot[bot].
• 🔥 Drop support for Python 3.7. PR #154 by @tiangolo.
• ⬆ Bump tiangolo/latest-changes from 0.3.1 to 0.3.2. PR #133 by @dependabot[bot].
• ⬆ Bump pypa/gh-action-pypi-publish from 1.10.3 to 1.11.0. PR #127 by @dependabot[bot].
• ⬆ Bump ruff from 0.6.9 to 0.7.1. PR #126 by @dependabot[bot].
• ⬆ Update pytest requirement from <8.0.0,>=7.0.1 to >=7.0.1,<9.0.0. PR #104 by @dependabot[bot].
• 👷 Add labeler GitHub Action. PR #102 by @tiangolo.
• 🔧 Re-create Python project config, dependencies, and CI, just to make CI run. PR #101 by @tiangolo.
• ⬆ Bump actions/checkout from 2 to 4. PR #62 by @dependabot[bot].
• 👷 Update issue-manager.yml GitHub Action permissions. PR #78 by @tiangolo.
• 👷 Update latest-changes GitHub Action. PR #79 by @tiangolo.
• 🔧 Add GitHub templates for discussions and issues, and security policy. PR #76 by @alejsdev.
• 👷 Add dependabot. PR #60 by @tiangolo.
• 👷 Update latest-changes GitHub Action. PR #59 by @tiangolo.

0.0.9

• ✨ Add poetry-version-plugin, remove importlib-metadata dependency. PR #32 by @tiangolo.

0.0.8.post1

• 💚 Fix setting up Poetry for GitHub Action Publish. PR #23 by @tiangolo.

0.0.8

• ⬆️ Upgrade importlib-metadata to 3.0.0. PR #22 by @tiangolo.
• 👷 Add GitHub Action latest-changes. PR #20 by @tiangolo.
• 💚 Fix GitHub Actions Poetry setup. PR #21 by @tiangolo.

0.0.7

• Update requirements of importlib-metadata to support the latest version 2.0.0. PR #11.

0.0.6

• Add support for SQLAlchemy extended types like sqlalchemy-utc: UtcDateTime. PR #9.

0.0.5

• Exclude columns before checking their Python types. PR #5 by @ZachMyers3.

0.0.4

• Do not include SQLAlchemy defaults in Pydantic models. PR #4.

0.0.3

• Add support for exclude to exclude columns from Pydantic model. PR #3.
• Add support for overriding the Pydantic config. PR #1 by @pyropy.
• Add CI with GitHub Actions. PR #2.

License

This project is licensed under the terms of the MIT license.