include

function include<TContext>(query): IncludeWrapper<TContext>;

Defined in: packages/db/src/query/builder/include-functions.ts:74

Includes a correlated subquery as a live child Collection on each parent row. Use toArray() or materialize() for inline values instead.

Type Parameters#

TContext#

TContext extends Context

Parameters#

query#

QueryBuilder<TContext>

Returns#

IncludeWrapper<TContext>

Example#

select(({ p }) => ({
  ...p,
  issues: include(
    q.from({ i: issues }).where(({ i }) => eq(i.projectId, p.id)),
  ),
}))