title: Update table using a list of dictionaries
body: <p>I have a list of dicts, this is actually a result from a previous select that I've converted to a dict (this was so I could edit the values of some columns):</p>
  
  <pre><code>sql_select = "SELECT key1, key2, value1, value2 FROM table_a"
  self.dbcur.execute(sql_select)
  matchedrows = self.dbcur.fetchall()
  
  dictrows = [dict(row) for row in matchedrows]
  for row in dictrows:
      ....process data, update some fields etc.
  </code></pre>
  
  <p>Now I would like to write my changes back to my sqlite table, my obvious choice was to try an update statement but I'm failing miserably trying to construct it (lack of knowledge)</p>
  
  <pre><code>sql_update = ('UPDATE table_a SET value1 = ?, value2 = ? WHERE key1 = ? and key2 =?')
  self.dbcur.execute(sql_update, dictrows)
  self.dbcon.commit()
  </code></pre>
  
  <p>Is this possible to do? Or should I be looking at an alternative method such as inserting to a temp table, etc.?</p>