AutoString doesn't work when using async

[matanper]

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

import asyncio
from typing import List, Optional

from sqlalchemy.ext.asyncio import AsyncEngine
from sqlalchemy.orm import sessionmaker
from sqlmodel import Field, SQLModel, create_engine
from sqlmodel.ext.asyncio.session import AsyncSession


class Hero(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    arr: List[str]


engine = AsyncEngine(create_engine(f"postgresql+asyncpg://localhost/tests", echo=True))
session_maker = sessionmaker(engine, class_=AsyncSession)


async def main():
    async with engine.connect() as conn:
        await conn.run_sync(SQLModel.metadata.create_all)

    async with session_maker() as session:
        session.add(Hero(id=1, arr=['a', 'b']))
        await session.commit()

if __name__ == "__main__":
    asyncio.run(main())

Description

When using sqlmodel with asyncpg the read/writes of List[str] fields fail. The table is created correctly as text type, but then it doesn't convert the list to a string when trying to save it.

sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $2: ['a', 'b'] (expected str, got list)
[SQL: INSERT INTO hero (id, arr) VALUES (%s, %s)]
[parameters: (1, ['a', 'b'])]

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.10.6

Additional Context

No response