title: SQLAlchemy Insert w/ Dictionary
body: <p>For this situation assume there is a table declared with the declarative base called Game, with column names "espn_game_id" and "a_name".  There is a session object open under the variable "s".  So this works:</p>
  
  <pre><code>s.add(Game(espn_game_id=888, a_name='lol'))
  s.commit()
  </code></pre>
  
  <p>This fails:</p>
  
  <pre><code>n = {"espn_game_id": 888, "a_name": 'lol'}
  s.add(Game(n))
  s.commit()
  </code></pre>
  
  <p>This works (assuming there is already an entry with espn_game_id==888):</p>
  
  <pre><code>n = {"a_name": 'lol'}
  s.query(Game).filter(Game.espn_game_id==888).update(n)
  s.commit()
  </code></pre>
  
  <p>Why does the second case fail and is there a way to get that type of syntax to work here?</p>