title: Dynamodb - Query by object property nested in array
body: <p>I am having an issues with understanding does dynamoDb supports filtering by object properties nested in array. Example:</p>
  
  <p>Consider that we have following table called "Street" where one item (row) in that table have following structure:</p>
  
  <pre><code>{
     name: "Street name",
     population: 20,
     houses: 5,
     people: [
        {
            first_name: "FName1",
            last_name: "LName1",
            ... other person's properties
        },
        {
            first_name: "FName2",
            last_name: "LName2",
            ... other person's properties
        },
        {
            first_name: "FName3",
            last_name: "LName3",
            ... other person's properties
        }
  
        ... etc
     ]
  }
  </code></pre>
  
  <p>We can consider in this scenario that "name" is dynamodb prefix = which means that we can query based on the street name.</p>
  
  <p>I am interested does dynamodb supports following logic: "Query based on street with specific name and filter it for the person with following specific name."</p>
  
  <p>The result would be something like (whole point is to return only one person/object from array which match the filter)</p>
  
  <pre><code>{
     name: "Street nameX",
     population: 20,
     houses: 5,
     people: [
        {
            first_name: "FNameX",
            last_name: "LNameX",
            ... other person's properties
        }
     ]
  }
  </code></pre>
  
  <p>Basically question is, can dynamoDb filter results after query based on the object properties nested in array.</p>
  
  <p><strong>Please make a note that I understand that I can achieve this with different table schema - but this example is used for simplicity and it is as it is - focusing question on 'does dynamoDB have support for something like this or not?'.</strong></p>