title: The nested query is not supported
body: <p>I have a query that is similar to the following (my actual query has three sections like this and then <code>Concat</code>s them together and applies some additional filters and sorting).</p>
  
  <pre><code>var articles = from p in Repository.Query&lt;Product&gt;()
                 let article = p.Article
                 let office = p.TariffCategory.Office
                 where p.IsDeleted == false
                 select new
                 {
                     OfficeId = office.Id,
                     Office = office.Name,
                     Category = p.TariffCategory.Description,
                     ArticleId = article.Id,
                     Article = article.Title,
                     Destinations = p.ProductDestinations.Select(d =&gt; new { Id = d.DestinationId, Name = d.Destination.Description }),
                     GlobalDestinations = p.AllDestinationsInOffice,
                     article.LastReviewedDate,
                     article.CreatedDate,
                     article.CreatedByEmployee
                 };
  </code></pre>
  
  <p>Everythings seems right except my assignment to <code>Destinations</code>. That line produces the following error.</p>
  
  <blockquote>
    <p>The nested query is not supported. Operation1='UnionAll' Operation2='MultiStreamNest'</p>
  </blockquote>
  
  <p>If I remove that line, everything works as expected. Is there any way to perform a query like this?</p>