Pedro de Mattia pdmtt

Senior dev at @invista-fidc. Bringing finance, law and data together.

pdmtt / sqlalchemy_with_pydantic_v2.py

Last active April 29, 2025 00:19 — forked from imankulov/sqlalchemy_with_pydantic.py

Using pydantic models as SQLAlchemy JSON fields (convert beween JSON and pydantic.BaseModel subclasses) with modern syntax

	import datetime
	from typing import TYPE_CHECKING, Any, Optional, final

	import sqlalchemy as sa
	from pydantic import BaseModel, Field
	from sqlalchemy.dialects.postgresql import JSONB
	from sqlalchemy.orm import Mapped, declarative_base, mapped_column, sessionmaker
	from typing_extensions import override

	if TYPE_CHECKING: