Providing a type of list[str] throws an error for a Postgres Array column in sqlmodel==0.0.9

[afraazali]

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 Session, SQLModel, create_engine
from sqlmodel.pool import StaticPool

class MetricAssignmentBase(SQLModel):
    package: Optional[List[str]]

engine = create_engine(
                "sqlite://",
                connect_args={"check_same_thread": False},
                poolclass=StaticPool,
            )
            SQLModel.metadata.create_all(bind=engine, tables=[])
            with Session(engine) as session:
                yield session

Description

The production database is a postgres db with a column named package which is of type array. It's an array of string

In sqlmodel==0.0.8 the above code worked when running tests in sqlite. In sqlmodel==0.0.9, the following error is thrown when trying to run tests:

  File "/home/deployer/.conda/envs/060eb14a/lib/python3.9/site-packages/sqlmodel/main.py", line 432, in get_column_from_field
    sa_type = get_sqlalchemy_type(field)
  File "/home/deployer/.conda/envs/060eb14a/lib/python3.9/site-packages/sqlmodel/main.py", line 425, in get_sqlalchemy_type
    raise ValueError(f"The field {field.name} has no matching SQLAlchemy type")
ValueError: The field package has no matching SQLAlchemy type

I've fixed the issue with doing the following:

package: Optional[List[str]] = Field(sa_column=Column(ARRAY(String)))

I checked the diff and saw the code change:

isinstance(field.type_, type) and field.shape == SHAPE_SINGLETON

which is what's causing this to stop working. I'm wondering is this a side effect of a bug fix or is this in preparation for Pydantic 2?

Thank you.

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.9

Python Version

3.10

Additional Context

No response