title: SQLAlchemy & dynamically setting Table column values
body: <p>Trying to do this:</p>
  
  <pre><code>meta = MetaData(bind=engine)
  meta.reflect(bind=engine, schema='schema')
  Mapper(Table, meta.tables['schema.table'])
  
  t = Table("schema.table", meta, autoload=True, autoload_with=engine)
  map = {'Col1': 'full_local_col1_name', 'Col2': 'full_local_col2_name'}
  
  for remote, local in map.items():
      t.set(local, values[remote])
  </code></pre>
  
  <p>The idea being that <code>values</code> is a <code>Dictionary</code> object obtained from another service, and I am mapping the column names to my local table.</p>
  
  <p>How can I accomplish this? SQLAlchemy's <code>Table</code> class has no <code>set</code> method.</p>