Python SQLite - select dicts - row factory lambda

sqlite_row_factory.py

import sqlite

conn = sqlite3.connect(database='my_cool_db.sqlite3')
# conn.row_factory = sqlite3.Row #  not the prettiest option
conn.row_factory = lambda c, r: dict([(col[0], r[idx]) for idx, col in enumerate(c.description)])

cursor = self.conn.cursor()

result = cursor.execute("SELECT * FROM test WHERE name='myname';")

print(result)
# [{'id': 1, 'name': 'myname', 'number': 1234567890}]