import sqlite3

dbconn = sqlite3.connect("db.sqlite")
dbconn.execute("CREATE TABLE test (first int, second int, third int)")
values = [1,2,3]
dbconn.execute("INSERT INTO test VALUES (?,?,?)", values)
dbconn.commit()
result = dbconn.execute("SELECT * FROM test").fetchall()
print (result)

import asqlite
import asyncio

async def foo():
    dbconn = await asqlite.connect("db.sqlite")
    await dbconn.execute("CREATE TABLE test (first int, second int, third int)")
    values = [1,2,3]
    await dbconn.execute("INSERT INTO test VALUES (?,?,?)", values)
    await dbconn.commit()
    cur = await dbconn.execute("SELECT * FROM test")
    result = await cur.fetchall()
    print (result)

asyncio.run(foo())