sqlmodel does not work with pydantic >= 2.12.0

[walsha2]

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

class ProjectEntity(SQLModel, table=True):
    __tablename__ = "project_entity"

Description

Creating models fails with pydantic >= 2.12.0. Here is the error:

class ProjectEntity(SQLModel, table=True):
../../../.venv/lib/python3.12/site-packages/sqlmodel/main.py:565: in __new__
    col = get_column_from_field(v)
          ^^^^^^^^^^^^^^^^^^^^^^^^
../../../.venv/lib/python3.12/site-packages/sqlmodel/main.py:714: in get_column_from_field
    sa_type = get_sqlalchemy_type(field)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^
../../../.venv/lib/python3.12/site-packages/sqlmodel/main.py:703: in get_sqlalchemy_type
    raise ValueError(f"{type_} has no matching SQLAlchemy type")
E   ValueError: <class 'dict'> has no matching SQLAlchemy type

This same code has always worked for all pydantic versions prior to 2.12.0.

I tested with sqlmodel == 0.0.25 and sqlmodel == 0.0.26 and both fail when I bump pydantic to 2.12.0, even though the dependency resolver for sqlmodel allows for it to be upgraded.

Operating System

macOS

Operating System Details

MacOS ARM 15.6.1

SQLModel Version

0.0.26

Python Version

Python 3.12.11

Additional Context

No response

[YuriiMotov]

Should be fixed in 0.0.27

[YuriiMotov]

Could you please share an MRE?
With the code from your initial comment I have

sqlalchemy.exc.ArgumentError: Mapper Mapper[ProjectEntity(project_entity)] could not assemble any primary key columns for mapped table 'project_entity'

[walsha2]

@YuriiMotov sorry, I was trying to obfuscate some stuff because this is in a private repo. I created a full working example:

• Works with sqlmodel (all versions) and pydantic < 2.12.0, e.g. 2.11.9
• Fails for sqlmodel (all versions) and pydantic >= 2.12.0

from typing import Annotated, Any

import sqlmodel
from pydantic import AfterValidator
from sqlalchemy.dialects.postgresql import JSONB
from sqlmodel import Field, SQLModel


def validate_json_length(value: dict[str, Any]) -> dict[str, Any]:
    if len(value) > 10:
        raise AssertionError("JSON should have at most 10 keys")
    return value


LengthConstrainedDict = Annotated[dict[str, Any], AfterValidator(validate_json_length)]


class TestProject(SQLModel, table=True):
    __tablename__ = "test_project"
    project_id: str = Field(
        description="The entity ID in database",
        primary_key=True,
    )
    project_metadata: LengthConstrainedDict = sqlmodel.Field(
        description="Metadata for the project",
        default_factory=dict,
        sa_type=JSONB,
    )

The issue seems to be with the annotated type LengthConstrainedDict and the validator. If I change LengthConstrainedDict to just dict[str, Any], the error does not happen.

[YuriiMotov]

So, this is the same issue as #1597

[walsha2]

Yes, it looks to be so. But #1597 did not exist when I created this discussion, it is new.

The example above is a complete working example that actually shows the new error:

E   ValueError: <class 'dict'> has no matching SQLAlchemy type

Feel free to close this discussion and link to #1597 - whatever makes more sense.

[YuriiMotov]

Yes, let's close this and refer it in #1597