Function buildNestedAggregateQuery

packages/db/tests/query/includes.test.ts:3991–4009

()

    describe(`nested aggregate: count comments per issue (as Collection)`, () => {
      function buildNestedAggregateQuery() {
        return createLiveQueryCollection((q) =>
          q.from({ p: projects }).select(({ p }) => ({
            id: p.id,
            name: p.name,
            issues: q
              .from({ i: issues })
              .where(({ i }) => eq(i.projectId, p.id))
              .select(({ i }) => ({
                id: i.id,
                title: i.title,
                commentCount: q
                  .from({ c: comments })
                  .where(({ c }) => eq(c.issueId, i.id))
                  .select(({ c }) => ({ total: count(c.id) })),
              })),
          })),
        )
      }

      it(`each issue gets its own comment count`, async () => {
        const collection = buildNestedAggregateQuery()