title: Sqlalchemy two filters vs one and
body: <p>This is a straight forward question. What is better to use, two <code>filters</code> or one <code>and_</code>? Is there any difference? </p>
  
  <pre><code>session.query(Test).filter(Test.id == X).filter(Test.test == Y).all()
  </code></pre>
  
  <p><strong>vs</strong></p>
  
  <pre><code>session.query(Test).filter(and_(Test.id == X, Test.test == Y)).all()
  </code></pre>
  
  <p>They will give me the same result but is there any difference i speed or anything else?</p>