title: Flask-SQLAlchemy filters and operators
body: <p>Flask-SQLAlchemy gives the option to filter a query. There are a wide number of ways you can filter a query - the examples the Flask-SQLAlchemy docs give:</p>
  
  <pre><code>User.query.filter_by(username='peter') # Returns all users named 'peter'
  User.query.filter(User.email.endswith('@example.com')) # Returns all users with emails ending in '@example.com'
  </code></pre>
  
  <p>I also found this for one-to-many relationships:</p>
  
  <pre><code>User.query.filter(User.addresses.any(address=address)) # Returns all users who have a particular address listed as one of their addresses
  </code></pre>
  
  <p>Questions:</p>
  
  <ul>
  <li>Does anyone know what filters are actually available to be used? I can't find a list of filters anywhere in the documentation, which makes it rather hard to query databases.</li>
  <li>In particular, what filter would I use to check if a user's email is contained within a particular set of email addresses?</li>
  </ul>