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

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.