import sqlite3

def dict_factory(cursor, row):
    d = {}
for idx, col in enumerate(cursor.description):
    d[col[0]] = row[idx]
return d
con = sqlite3.connect(':memory:')
con.row_factory = dict_factory
cur = con.cursor()
cur.execute('select 1 as a')
print(cur.fetchone()['a'])
Как я могу получить dict из запроса sqlite?