def _build_query(self, limit=None, order=None):
    base_query = select("*").select_from(text(self.cs_table_name))
    if self.config.where or self._additional_filters:
        # conditions is the list of where + additional filters
        conditions = []
        if self.config.where:
            conditions += self.config.where
        if self._additional_filters:
            conditions += self._additional_filters

        query_params = {}
        condition_strings = []
        valid_operators = ["=", ">", "<", ">=", "<=", "LIKE", "!=", "IN", "NOT IN"]

        for i, condition in enumerate(conditions):
            if len(condition) == 3:
                column_name, operator, value = condition
                if operator in valid_operators:
                    self._validate_column_name(column_name)

                    condition_strings.append(f"{column_name} {operator} :value_{i}")
                    query_params[f"value_{i}"] = value

        if condition_strings:
            where_clause = " OR ".join(condition_strings)  # Changed from AND to OR
            base_query = base_query.where(
                text(where_clause).bindparams(**query_params)
            )

    if order:
        base_query = base_query.order_by(asc(text(order)))

    if limit:
        base_query = base_query.limit(limit)

    return base_query