Function buildNestedQuery

packages/db/tests/query/includes.test.ts:1138–1159

()

  //   toArray → toArray        — both levels are plain arrays
  describe(`nested includes: Collection → Collection`, () => {
    function buildNestedQuery() {
      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,
              comments: q
                .from({ c: comments })
                .where(({ c }) => eq(c.issueId, i.id))
                .select(({ c }) => ({
                  id: c.id,
                  body: c.body,
                })),
            })),
        })),
      )
    }

    it(`supports two levels of includes`, async () => {
      const collection = buildNestedQuery()