nest object access features doc

[Ahoo-Wang]

<?xml version="1.0" encoding="utf-8" ?>
<SmartSqlMap Scope="NestTest" xmlns="http://SmartSql.net/schemas/SmartSqlMap.xsd">
  <Statements>
    
    <Statement Id="QueryNestObject2">
      SELECT @User.Info.Id
    </Statement>

    <Statement Id="QueryNestArray">
      SELECT @Order.Items[0]
    </Statement>

    <Statement Id="QueryNestDic">
      SELECT @Order.Items[Id]
    </Statement>

    <Statement Id="QueryNestArrayObject">
      SELECT @Order.Items[0].Name
    </Statement>

    <Statement Id="FilterNestObject1">
      <IsEqual Property="User.Id" CompareValue="1">
        SELECT @User.Id
      </IsEqual>
    </Statement>

    <Statement Id="FilterNestObject2">
      <IsEqual Property="User.Info.Id" CompareValue="1">
        SELECT @User.Info.Id
      </IsEqual>
    </Statement>

    <Statement Id="FilterNestArray">
      <IsEqual Property="Order.Items[0]" CompareValue="1">
        SELECT @Order.Items[0]
      </IsEqual>
    </Statement>

    <Statement Id="FilterNestDic">
      <IsEqual Property="Order.Items[Id]" CompareValue="1">
        SELECT @Order.Items[Id]
      </IsEqual>
    </Statement>

    <Statement Id="FilterNestArrayObject">
      <IsEqual Property="Order.Items[0].Name" CompareValue="SmartSql">
        SELECT @Order.Items[0].Name
      </IsEqual>
    </Statement>
    
  </Statements>
</SmartSqlMap>

-> https://github.com/Smart-Kit/SmartSql-Docs