How can I get dict from sqlite query?db = sqlite.connect("test.sqlite") res = db.execute("select * from table") With iteration I get lists coresponding to the rows. for row in res: print row I can get name of the columns col_name_list = [tuple[0] for tuple in res.description] But is there some function or setting to get dictionaries instead of list? {'col1': 'value', 'col2': 'value'} or I have to do myself?
