sqlite3

import sqlite3

conn = sqlite3.connect("app.db")
conn.execute(
    "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT NOT NULL)"
)
conn.commit()

Parameterized queries

conn.execute("INSERT INTO users (name) VALUES (?)", ("alice",))

Transactions

try:
    conn.execute("UPDATE accounts SET balance = balance - 10 WHERE id = 1")
    conn.commit()
except Exception:
    conn.rollback()
    raise