I believe that the JSON_EXISTS function [1] can do this kind of filtering, and
Calcite supports it [2].
Julian
[1]
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adjsn/condition-JSON_EXISTS.html#GUID-8A0043D5-95F8-4918-9126-F86FB0E203F0
Hi Calcite developers,
As we know, MongoDB can store complex JSON objects with deep nested
object/array data. I'd like to know whether calcite SQL parser allow filter
condition with hierarchical element reference like this?
select * from doc where key0.key1.key2[0].key3[0]
1
Here is