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 an example entry of the collection:
{
"key0": {
"key1": {
"key2": [
{
"key3": [
1,
2,
3
]
}
]
}
}
}
BTW, I see that there are some commercial tools like Studio 3T has good SQL
query capability, not sure if the SQL syntax is their own or some standard SQL
dialect.
Thanks,
Justin
