Function buildAggregateToArrayQuery

packages/db/tests/query/includes.test.ts:3957–3970

()

    describe(`single-group aggregate: count issues per project (as toArray)`, () => {
      function buildAggregateToArrayQuery() {
        return createLiveQueryCollection((q) =>
          q.from({ p: projects }).select(({ p }) => ({
            id: p.id,
            name: p.name,
            issueCount: toArray(
              q
                .from({ i: issues })
                .where(({ i }) => eq(i.projectId, p.id))
                .select(({ i }) => ({ total: count(i.id) })),
            ),
          })),
        )
      }

      it(`each project gets its own aggregate result as an array`, async () => {
        const collection = buildAggregateToArrayQuery()