JSON Support

    PartiQL extends SQL to allow you to query and unnest nested collections. In OpenSearch, this is very useful to query a JSON index with nested objects or fields.

    To follow along, use the operation to index some sample data:

    Explain:

    Result set:

    Example 2: Unnesting in existential subquery

    Explain:

    Result set:

    employeeName
    Bob Smith
    Jane Smith