[BUG] Criteria API does not allow to pass a list of values for ARRAY_CONTAINS criteria type about azure-sdk-for-java HOT 2 OPEN

I also noticed that the associated query string for ARRAY_CONTAINS is also generated incorrectly.
According to the documentation, the function is structured as follows:
ARRAY_CONTAINS(<array_expr>, <expr> [, <bool_expr>])
ARRAY_CONTAINS(@param, r.partitionKey, true)

However, the query string is generated as follows:

String.format("%s(r.%s, @%s, true)", sqlKeyword, subject, parameter);

=> ARRAY_CONTAINS(r.partitionKey, @param, true)

https://github.com/Azure/azure-sdk-for-java/blob/main/sdk/spring/azure-spring-data-cosmos/src/main/java/com/azure/spring/data/cosmos/core/generator/AbstractQueryGenerator.java#L114

from azure-sdk-for-java.

Hi @HeneryHawk thanks for reaching out to us via Github. Sorry for the delay, it seems our issue-triage-bot didn't label your issue earlier.

@kushagraThapar could you help route this Cosmos question?

from azure-sdk-for-java.