As of June 2020, Azure Cosmos DB supports performant case-insensitive searches for certain string functions like "contains". See this MSFT dev-blogs link. This is great, because string-functions usually kill the performance of "regular" databases.
My question: We are using the Gremlin-Graph-API and would urgently need this feature because a case-sensitive search kills the user-experience. Is there a way to do it?
Sample:
g.V().has("name", containing("Fra")) => g.V().has("name", containing("Fra", <caseInsensitive=true>))
As a workaround, you can create a UDF as mentioned in the issue and then consume it as a sql query. However just check if it is feasible as per your requirements.
At the same time, I would recommend you to upvote the feature requested by a user on the same case-insensitive searches. More votes on it makes the product team prioritize the feature accordingly:
https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/41097427-gremlin-api-regex-and-case-insensitive-match