python - Is there any way to access SQL row data by the column name?

Question

After I used fetchall(), I got this error:

TypeError: tuple indices must be integers, not str

very similar to this person's question, which I upvoted: TypeError: tuple indices must be integers, not str

Just wondering... is there anyway I could get the data in such a way that would allow me to access data by writing row["column_name"] instead of row[index]?

Answer 1

The sqlite interface includes a row_factory that enables addressing returned elements by column name.