CMISQL queries on multi-valued properties fail on DBS MongoDB

When doing a CMISQL query like:

SELECT cmis:name FROM File WHERE ANY dc:contributors IN ('pete', 'bob')

This is translated to NXQL:

SELECT DISTINCT dc:title, ecm:uuid, ecm:primaryType FROM Document WHERE ecm:primaryType IN ('File', 'ComplexFile') AND ecm:currentLifeCycleState <> 'deleted' AND ecm:isProxy = 0 AND dc:contributors/* = 'pete'

Which fails because DBS cannot interpret DISTINCT:

Invalid query: CMISQL: SELECT cmis:name FROM File WHERE 'pete' = ANY dc:contributors, Failed to execute query: NXQL: SELECT DISTINCT dc:title, ecm:uuid, ecm:primaryType FROM Document WHERE ecm:primaryType IN ('File', 'ComplexFile') AND ecm:currentLifeCycleState <> 'deleted' AND ecm:isProxy = 0 AND dc:contributors/* = 'pete', SELECT DISTINCT not supported on DBS