[META] Support nested field type in Calcite #4625
Description
Problem Statement
The OpenSearch nested type is not fully supported in SQL plugin. https://github.com/opensearch-project/sql/blob/main/docs/user/ppl/limitations/limitations.rst#nested-field-behavior
The main issues in legacy engine and SQL query listed in #52
The main issues in v3 and PPL will list in the subtask of this meta issue.