SQLAlchemy – How to filter_by multiple dynamic OR values?

Solution

def company_filter(db, filter_type, filter_value, minmax):
    match filter_type:
        case "industry":
            filter_list = []

            for filter in filter_value:
                filter_list.append(Company.industry == filter)

            return db.query(Company).with_entities(Company.id, Company.symbol, Company.name, Company.monthly_exp).filter(or_(*filter_list))
        ...