PySQLX-Engine with async core

[carlos-rian]

First Check

• [X] I added a very descriptive title to this issue.
• [X] I used the GitHub search to find a similar issue and didn't find it.
• [X] I searched the SQLModel documentation, with the integrated search.
• [X] I already searched in Google "How to X in SQLModel" and didn't find any information.
• [X] I already read and followed all the tutorial in the docs and didn't find an answer.
• [X] I already checked if it is not related to SQLModel but to Pydantic.
• [X] I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• [X] I commit to help with one of those options 👆

Example Code

import asyncio

from sqlx_engine import SQLXEngine

uri = "file:./db.db"
db = SQLXEngine(provider="sqlite", uri=uri)

async def main():
    await db.connect()
    rows = await db.query(query="select 1 as number")
    print(rows)

asyncio.run(main())

Description

Check the possibility of using PySQLX-Engine as core to execute raw sql.

Maybe create a wrapper to compile the code in sqlalchemy and run in PySQLX-Engine.

Doc: https://carlos-rian.github.io/pysqlx-engine/

Operating System

Linux, Windows, macOS

Operating System Details

No response

SQLModel Version

v0.0.6

Python Version

^3.8

Additional Context

sqlalchemy currently supports executing sql codes asynchronously on some databases using some drivers.

But not all banks are supported. PySQLX-Engine was born asynchronous.