title: In SQLAlchemy, how to input a list and get eligible items in the table?
body: <p>Table A has two columns: <code>ID</code> and <code>name</code></p>
  
  <p>I want to input 3 ID and get 3 name, my way looks like</p>
  
  <pre><code>ID_list = [1,3,4]
  DBSession.query(TableA).filter(or_(TableA.id == input_ID_list[0], TableA.id == input_ID_list[1], TableA.id == input_ID_list[2])
  </code></pre>
  
  <p>which looks quite foolish. </p>
  
  <p>Is there a cleaner way to finish this job in SQLAlchemy, such as this:</p>
  
  <pre><code>DBSession.query(TableA).filter(TableA.id.in_(input_ID_list))
  </code></pre>