Flask-SQLAlchemy filters and operators

For a list of filters check SQLAlchemy documentation

what filter would I use to check if a user's email is contained within a particular set of email addresses?

Columns have a .in_() method to use in query. So something like:

res = User.query.filter(User.email.in_(('[email protected]', '[email protected]')))

Here you can find the list of column method for expressions.