Cannot use the IN clause within the SUM method

[idamerce]

Describe the bug
Hello everyone,
Is there anyone here familiar with using SQL on OpenSearch? We are encountering errors when running our queries and would greatly appreciate any assistance or insights you could provide.

To Reproduce
Specifically, we are facing issues with queries of type :

this works:

SELECT count(*) AS fps_count
FROM `my-alias-db`
WHERE status IN ('AA','BB')

but this does not (needed for creating new metrics in superset)

SELECT SUM(CASE WHEN status IN ('AA', 'BB') THEN 1 ELSE 0 END) AS status_sum
FROM 'my-alias-db'

Expected behavior
I'm expecting to have same results but I'm getting this error:
odelasticsearch error: Error (NullPointerException): {'error': {'reason': 'Invalid SQL query', 'details': '', 'type': 'NullPointerException'}, 'status': 400}

Host/Environment (please complete the following information):

• OS: [ opensearch on aws]

Additional context
need to use my query for creating new metrics on superset

[dblock]

[Catch All Triage - 1, 2, 3, 4, 5]