input={"mm_foot_length":10} and_=sqlalchemy.sql.expression.and_ filter=and_( *list( and_( getattr(Footwear,k) >= v +10, getattr(Footwear,k) <= v +5 ) ) for k,v in input.values() ) query.filter(filter)