db.session.query(User).filter_by(name='John Smith')

from sqlalchemy.sql import exists
print session.query(exists().where(User.email == '...')).scalar()