SQLModel.__new__ return-type Any --> Self

[msftcangoblowm]

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

unmodified relevant portions from sqlmodel.main

_TSQLModel = TypeVar("_TSQLModel", bound="SQLModel")

class SQLModel(BaseModel, metaclass=SQLModelMetaclass, registry=default_registry):

    def __new__(cls, *args: Any, **kwargs: Any) -> Any: ...

Can see __new__ return type is Any

Propose

__new__ return type Self

After some research, pep673 rejects the case using Self when metaclasses are involved

Likewise, we reject Self in metaclasses. Self in this PEP consistently refers to the same type (that of self). But in metaclasses, it would have to refer to different types in different method signatures. For example, in mul, Self in the return type would refer to the implementing class Foo, not the enclosing class MyMetaclass. But, in new, Self in the return type would refer to the enclosing class MyMetaclass. To avoid confusion, we reject this edge case.

Operating System

Linux

Operating System Details

Void Linux LXDE

SQLModel Version

0.0.24

Python Version

3.9.16

Additional Context

pydantic 2.11.7
pydantic_core 2.33.2
SQLAlchemy 2.0.40