it is now available e.g.

SELECT ssot__Name__c FROM ssot__Account__dlm WHERE LOWER(ssot__Name__c) LIKE LOWER('WhAtEveR%') LIMIT 10

works