Silverstripe4 allows to combine AND and OR clauses in ORM filtering

DataFilterAnyMultiExtension.php

<?php

namespace App\Extensions;
/*
Config
```
SilverStripe\ORM\DataList:
  extensions:
    - App\Extensions\DataFilterAnyMultiExtension
```
*/

use SilverStripe\ORM\DataExtension;

class DataFilterAnyMultiExtension extends DataExtension {

    public function filterAnyMulti() {
		$whereArgumentsCombo = func_get_args();

		return $this->owner->alterDataQuery(function($query, $list) use ($whereArgumentsCombo) {
			$ORquery = $query->disjunctiveGroup();

            foreach($whereArgumentsCombo as $whereArguments){

                $ANDquery = $ORquery->conjunctiveGroup();
                foreach($whereArguments as $field => $value) {
                    $fieldArgs = explode(':',$field);
                    $field = array_shift($fieldArgs);
                    $filterType = array_shift($fieldArgs);
                    $modifiers = $fieldArgs;

                    // This is here since PHP 5.3 can't call protected/private methods in a closure.
                    $t = singleton($list->dataClass())->dbObject($field);
                    if($filterType) {
                        $className = "{$filterType}Filter";
                    } else {
                        $className = 'ExactMatchFilter';
                    }
                    if(!class_exists($className)){
                        $className = 'ExactMatchFilter';
                        array_unshift($modifiers, $filterType);
                    }
                    $t = new $className($field, $value, $modifiers);
                    $t->apply($ANDquery);
                }

            }
		});
	}
}