Bad type annotation for sa_type

[AlanBogarin]

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 Optional
from sqlmodel import SQLModel, Field, DateTime


def utcnow() -> datetime:
    return datetime.now(timezone.utc)


class BaseModel(SQLModel):
    id: int | None = Field(default=None, primary_key=True)
    created_at: Optional[datetime] = Field(
        sa_type=DateTime(timezone=True), default_factory=utcnow
    )
    updated_at: Optional[datetime] = Field(
        sa_type=DateTime(timezone=True),
        default_factory=utcnow,
        sa_column_kwargs={"onupdate": utcnow},
    )

Description

When providing an argument to sa_type I always see that it's an instance of a class, and the linter doesn't like it because it should be something compatible with type[Any]. I think in older versions of sqlmodel this parameter used to be Any.

I think it could be replaced with sqlalchemy.TypeEngine[Any] since most values for sa_type are subclasses of that.

Argument of type "DateTime" cannot be assigned to parameter "sa_type" of type "Type[Any] | PydanticUndefinedType" in function "Field"

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.24

Python Version

3.13.9

Additional Context

VSCode + Pylance, strict type checking mode

[YuriiMotov]

Thanks for reporting!

This is a duplicated of #955

And, there is a PR already to fix this: #1345