SQLModel.model_validate_json does not use attribute JSON validation schemas

[fkaab]

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 base64 import b64decode, b64encode
from typing import Any
from pydantic import BaseModel, GetCoreSchemaHandler
from sqlmodel import SQLModel
from pydantic_core import CoreSchema, core_schema

#%%

class CustomType(int):

    @classmethod
    def __get_pydantic_core_schema__(
        cls, source_type: Any, handler: GetCoreSchemaHandler
    ) -> CoreSchema:
        
        def json_schema(x):
            print("json schema")
            return x

        def python_schema(x):
            print("python schema")
            return x

        return core_schema.json_or_python_schema(
            python_schema=core_schema.chain_schema(
                [
                    core_schema.int_schema(),
                    core_schema.no_info_plain_validator_function(python_schema)
                ]
            ),
            json_schema=core_schema.chain_schema(
                [
                    core_schema.int_schema(),
                    core_schema.no_info_plain_validator_function(json_schema)
                ]
            ),
        )


# %%
class BaseModelTest(BaseModel):
    value: CustomType

class SQLModelTest(SQLModel):
    value: CustomType

# %%
a = BaseModelTest(value=1)
b = a.model_dump_json()
c = BaseModelTest.model_validate_json(b)

# %%
a = SQLModelTest(value=1)
b = a.model_dump_json()
c = SQLModelTest.model_validate_json(b)

Description

• Create a custom type CustomType with a distinct JSON and python validation schemas.
• Create SQLModel subclass SQLModelTest with said custom type as an attribute.
• SQLModelTest.model_validate_json, unlike the equivalent BaseModelTest.model_validate_json, uses the python validation schema instead of the JSON validation schema.

Operating System

Linux

Operating System Details

Fedora 39

SQLModel Version

0.0.14

Python Version

3.9.18

Additional Context

No response