Description

When fetching the connection from a cursor it responds with the underlaying sqlite3 connection instead of the aiosqlite. This makes the application crash with the following message if trying to run a commit on it:
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 139659649398464 and this is thread id 13...

    con = await aiosqlite.connect(":memory:")
    cur = await con.cursor()

    await con.commit()
    await cur.connection.commit()  # This row causes a crash since the connection fetched is not the created aiosqlite connection, but instead the underlaying sqlte3 connection

Details

• OS: Linux (6.2.0)
• Python version: 3.11.6
• aiosqlite version: 0.20.0 (latest pip install?)
• Can you repro on 'main' branch? Have not tried
• Can you repro in a clean virtualenv? Yes (running unitests with tox)