foo.py

import asyncio
import aiosqlite
from pathlib import Path

DBNAME = Path("foo.sql")

async def foo():
    print("create")

    async with aiosqlite.connect(DBNAME) as db:
        cursor = await db.execute("CREATE TABLE test (str TEXT)")
        await db.commit()

    print("insert")

    async with aiosqlite.connect(DBNAME) as db:
        cursor = await db.execute("INSERT INTO test VALUES ('hello world')")
        await db.commit()

    print("select")

    async with aiosqlite.connect(DBNAME) as db:
        cursor = await db.execute("SELECT * FROM test")
        rows = await cursor.fetchall()
        print(f"{rows = }")

    print("done")

if __name__ == "__main__":
    DBNAME.unlink(missing_ok=True)
    asyncio.run(foo())