Does Oracle NoSQL Database support the nested case expression in SQL queries to handle data anomalies?

Solution for Does Oracle NoSQL Database support the nested case expression in SQL queries to handle data anomalies?
is Given Below:

I found some anomalies in the third party source JSON documents we imported. We need to handle such data with more sophisticated queries. Our application needs to identify specific problems with the JSON data.

For example, we will need something like the following nested case expression. Does Oracle NoSQL Database SQL query support the following?

CASE
     WHEN EXISTS fied1
     THEN
        CASE
           WHEN EXISTS field2
           THEN
              CASE
                 WHEN field3array[] =any null
                 THEN "this is the one to pick!"
                 ELSE "otherwise use this one!"
              END
           WHEN field4array[] =any null
           THEN "nothing to show here!"
           ELSE "show this!"
        END
     ELSE "game over!"
END