How to use SELECT statement to get data from SQlite table using with dictionary values?
Have you tried implementing row factory? https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.row_factory
More details here: https://xbuba.com/questions/3300464/how-can-i-get-dict-from-sqlite-query