sqlalchemy 查询条件 and or

from sqlalchemy import or_ 
base_query = UserModel.query
      .filter(or_(UserModel.user == "Lily" , UserModel.age == 22))
     .all()

base_query = UserModel.query
      .filter_by(user = "Lily")
        .filter_by(gender = "女")
     .all()

from sqlalchemy import or_, and_
base_query = UserModel.query
     .filter(or_(and_(UserModel.user == "Lily", UserModel.gender == "女" ), UserModel.age == 22))
      .all()