title: Is it possible to do a nested query builder in AdonisJs with Lucid?
body: <p>I want to know if it is possible to do a nested ".scope" query with Lucid in AdonisJs? I want to get all Orders that don't have the 'd' status in OrderItems for a given Office (Laravel uses whereHas('orders.items') for this).</p>
  
  <p>An example:</p>
  
  <pre><code>const office = yield Office
    .query()
    .with('orders.items')
    .where('id', officeId)
    .scope('orders.items', (builder) =&gt; {
      builder.whereNot('status','d')
    })
    .first()
  </code></pre>
  
  <p>But this only filters out all OrderItems that have the 'd' status, so I still get a list that contains Orders with empty Item arrays:</p>
  
  <pre><code>office: {
    orders: [{
      items: [{
        status: 'p'
      }, {
        status: 'c'
      }]
    },{
      items: []
    },{
      items: []
    }]]
  }
  </code></pre>
  
  <p>I want to get this result:</p>
  
  <pre><code>office: {
    orders: [{
      items: [{
        status: 'p'
      }, {
        status: 'c'
      }]
    }]]
  }
  </code></pre>