Pydantic 2.12 causes error: AwareDatetime has no matching SQLAlchemy type

[jiahuei]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from datetime import datetime, timezone
from typing import Annotated, Any
from zoneinfo import ZoneInfo

from pydantic import AfterValidator
from pydantic.types import AwareDatetime
from sqlalchemy.dialects.postgresql import JSONB
from sqlalchemy.orm import declared_attr
from sqlmodel import (
    DateTime,
    MetaData,
    SQLModel,
)
from sqlmodel import Field as SqlField


def _to_utc(d: AwareDatetime) -> AwareDatetime:
    return d.astimezone(timezone.utc)


DatetimeUTC = Annotated[AwareDatetime, AfterValidator(_to_utc)]


def now(tz: str = "UTC") -> datetime:
    return datetime.now(ZoneInfo(tz))


class JamaiSQLModel(SQLModel):
    metadata = MetaData(schema="jamai")

    @declared_attr
    def __tablename__(cls) -> str:
        return cls.__name__


class _TableBase(JamaiSQLModel, str_strip_whitespace=True):
    meta: dict[str, Any] = SqlField(
        {},
        sa_type=JSONB,
        description="Metadata.",
    )
    created_at: DatetimeUTC = SqlField(
        default_factory=now,
        sa_type=DateTime(timezone=True),
        description="Creation datetime (UTC).",
    )
    updated_at: DatetimeUTC = SqlField(
        default_factory=now,
        sa_type=DateTime(timezone=True),
        description="Update datetime (UTC).",
    )

Description

The code works with Pydantic 2.11, but fails with error ValueError: <class 'pydantic.types.AwareDatetime'> has no matching SQLAlchemy type when using 2.12.x

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.27

Python Version

Python 3.12.9

Additional Context

No response

[YuriiMotov]

Can't reproduce this. The code example doesn't give me any error.

@jiahuei, could you please check if it's still an issue for you?