Do you support importing Asynchronous Sessions from sqlmodel？

[yuanjie-ai]

Privileged issue

• I'm @tiangolo or he asked me directly to create an issue here.

Issue Content

from sqlmodel import AsyncSession

[AtticusZeller]

here for you

from sqlmodel.ext.asyncio.session import AsyncSession

you can search more info in discussion if interested

[supermacro]

Relatedly, suppose I wanted to use sqlmodel with https://fastapi-users.github.io/ ... the docs require that I create an async engine via create_async_engine... How can I integrate this with sqlmodel?

More generally, want to learn how to use async io with sqlmodel

[AtticusZeller]

Relatedly, suppose I wanted to use sqlmodel with https://fastapi-users.github.io/ ... the docs require that I create an async engine via create_async_engine... How can I integrate this with sqlmodel?

More generally, want to learn how to use async io with sqlmodel

1. sqlmodel is built upon SQLAlchemy, so create_async_engine can normally work with sqlmodel without conflicts.

2. i quit async orm because it annoying to write test for them