to_db = [(i['col1'], i['col2']) for i in dr]
cur.executemany('INSERT INTO t (col1, col2) VALUES (?, ?);', to_db)
con.commit()
con.close()
Importing a CSV file into a sqlite3 database table using Python