Pycharm unexpected type(s) for date field

[SergeyKapshuchenko]

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 Hero(SQLModel, table=True):
    __tablename__ = "hero"
    created_date: date = Field(default_factory=lambda: datetime.now(UTC).date())


def get_min_created_date() -> date:
    with get_session() as session:
        query = select(Hero.created_date).where(Statistic.id == 1)
        created_date = session.exec(query).first()

Description

Hi, pycharm complains about unexpected type when I select fields of date type.

1. Create model Hero
2. Create field created_date: date of date type
3. select it using select(Hero.created_date)
4. pycharm warning about - Unexpected type(s): (date) Possible type(s): (TypedColumnsClauseRole[_T0] | SQLCoreOperations[_T0] | Type[_T0]) (_TScalar_0)
5. return type for value is also not working - created_date: Row | RowMapping | None

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.16

Python Version

3.12

Additional Context

No response

[SergeyKapshuchenko]

but works great with datetime field

[SergeyKapshuchenko]

any updates ?

[anschweitzer]

Same issue with PyCharm 2025.1.1.1 and SQLModel 0.0.24, using this tutorial code

[monchin]

From the source code

_TScalar_0 = TypeVar(
    "_TScalar_0",
    Column,  # type: ignore
    Sequence,  # type: ignore
    Mapping,  # type: ignore
    UUID,
    datetime,
    float,
    int,
    bool,
    bytes,
    str,
    None,
)

You can see that date is not supported. Instead you should use datetime for better lint support. Of course I think your request is quite reasonable, so maybe you could make a PR to add date in _TScalar_1/2/3 to fix this issue.

[YuriiMotov]

Use col():

        query = select(col(Hero.created_date))

---

---