import sqlite3

con = sqlite3.connect(":memory:", autocommit=False)
con.row_factory = sqlite3.Row
try:
    with con:
        con.execute("CREATE TABLE books (id INTEGER PRIMARY KEY, title TEXT)")
        con.executemany("INSERT INTO books (title) VALUES (?)", [("SQL notes",), ("Data diary",)])
    for row in con.execute("SELECT id, title FROM books ORDER BY id"):
        print(row["id"], row["title"])
finally:
    con.close()