To validate that the parameter types are instances of sqlalchemy.sql.sqltypes

[tiankongzhise]

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 sqlmodel import SQLModel, Field,  create_engine , Session,select
from sqlmodel import Column,Integer,DateTime
import os
import dotenv
dotenv.load_dotenv()


# 从环境变量中读取配置
DB_USER = os.getenv('DB_USER')
DB_PASSWORD = os.getenv('DB_PASSWORD')
DB_HOST = os.getenv('DB_HOST')
DB_PORT = os.getenv('DB_PORT')

test_engine = create_engine(
    f"mysql+pymysql://{DB_USER}:{DB_PASSWORD}@{DB_HOST}:{DB_PORT}/test_db",
    echo=True
)

class TestTable(SQLModel, table=True):
    __tablename__ = 'test_table'
    id:int = Field(sa_column=Column(Integer, autoincrement=True, nullable=False,default=None, primary_key=True, index=True))
    name:str
    age:int
    created_at:DateTime

    class Config:
        arbitrary_types_allowed = True

with Session(test_engine) as session:
    result = session.exec(select(TestTable)).all()
    print(result)

Description

When running, the error raise ValueError(f"{type_} has no matching SQLAlchemy type") occurs, which is quite absurd.
I suggest adding a check for sqlalchemy.sql.sqltypes itself in the SQLModelMetaclass.get_sqlalchemy_type method.
For example, modifying the line
if issubclass(type_, datetime):
to
if issubclass(type_, datetime) | issubclass(type_, DateTime)
would resolve this issue.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.12.1

Additional Context

No response