[META] Support nested field type in Calcite

[LantaoJin]

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.