title: SQLALchemy dynamic filter_by
body: <p>I know you can build dynamic filters for queries for SQLAlchemy by supplying <code>**kwargs</code> to <code>filter_by</code>. </p>
  
  <p>For example  </p>
  
  <pre><code>    filters = {'id': '123456', 'amount': '232'}
      db.session.query(Transaction).filter_by(**filters)
  </code></pre>
  
  <p>Below is my question:</p>
  
  <p>What if I need to query by "greater than" or "less than" clauses?
  For example (raw SQL):</p>
  
  <pre><code> select * from transaction t 
   where t.amount &gt; 10 and t.amount &lt; 100;
  </code></pre>