import sqlite3 db = sqlite3.connect(':memory:') db.execute("""CREATE TABLE "te""st"("in""dex" NUMERIC)""") db.execute("""INSERT INTO "te""st" VALUES(1)""") for r in db.iterdump(): print(r)