title: Select couchbase nested object
body: <p>I have a bunch of documents with a structure like this:</p>
  
  <pre><code>{
    "month": 11,
    "year": 2017,
    //other fields
    "Cars":[
    {
      "CarId": 123,
      // other fields
    },
    {
      "CarId": 456,
      // other fields
    }
    // other cars
     ]
  }
  </code></pre>
  
  <p>I am searching for a concrete car instance with <code>id = 456</code>. So far I have:</p>
  
  <pre><code>SELECT Cars
  FROM DevBucket
  WHERE year = 2017
      AND month = 11
      AND [CarId=456]
  </code></pre>
  
  <p>Couchbase returns correct document (which contains target car). However the output includes an array of all <code>Car</code> nodes within a document, but I'd like to have a single car (as if I use <code>SELECT Cars[1]</code> in the example above)</p>
  
  <p>Search through couchbase tutorials didn't give me an answer. Is there a better way?</p>