date / datetime handling inconsistency between pydantic BaseModel and SQLModel with table=True

[0x143]

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

import datetime
from sqlmodel import Field, SQLModel, create_engine

# OK: table=False, date field is converted
class TestTableFalse(SQLModel, table=False):                 
    id: int | None = Field(default=None, primary_key=True) 
    creation_date: datetime.date                           

type(TestTableFalse(creation_date="2024-01-01").creation_date)
# datetime.date

# WRONG: table=True, date field is not converted
class TestTableTrue(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    creation_date: datetime.date

type(TestTableTrue(creation_date="2024-01-01").creation_date)
# str


# pydantic: date field is converted
from pydantic import BaseModel, Field


class TestPydantic(BaseModel):                   
    id: int | None = Field(default=None, primary_key=True)  
    creation_date: datetime.date                            


type(TestPydantic(creation_date="2024-01-01").creation_date)
# datetime.date

Description

When SQLModel model is created with table=False fields which are annotated with datetime.date / datetime.datetime are automatically converted to the annotated types. This behavior is consistent with behavior of classes extending pydantic.BaseModel.

However, when table=True, that's no longer the case.

Is this an expected behavior?

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.13.0

Additional Context

No response