title: Sqlite query to python dictionary
body: <p>I have searched the docs and SO and could not find anything to resolve my issue. I am trying to call a select from my sqlite database and add it to a dictionary with the columns as keys. When I do this it returns a row for each column/key. It is has 14 columns and if I only have 4 rows it repeats for each one. This was the first attempt</p>
  
  <pre><code>columns = [desc[0] for desc in cursor.description]
  results = []
  for row in r:
      Summary = {}
      items = zip(columns, row)
      for (items, values) in items:
          Summary[items] = row
          results.append(Summary)
  </code></pre>
  
  <p>Then I also tried the row_factory as given in the docs. That didn't work. My end goal is to be able to print out to a text file verticly by using</p>
  
  <pre><code>for x in results:
      print x[name]
      print x[email]
      etc
  </code></pre>
  
  <p>Any help is appreciated</p>