function queryOnce<TContext>(queryFn): Promise<InferResultType<TContext>>;

Defined in: packages/db/src/query/query-once.ts:47

Executes a one-shot query and returns the results as an array.

This function creates a live query collection, preloads it, extracts the results, and automatically cleans up the collection. It's ideal for:

• AI/LLM context building
• Data export
• Background processing
• Testing

TContext extends Context

(q) => QueryBuilder<TContext>

A function that receives the query builder and returns a query

Promise<InferResultType<TContext>>

A promise that resolves to an array of query results

// Basic query
const users = await queryOnce((q) =>
  q.from({ user: usersCollection })
)

// With filtering and projection
const activeUserNames = await queryOnce((q) =>
  q.from({ user: usersCollection })
   .where(({ user }) => eq(user.active, true))
   .select(({ user }) => ({ name: user.name }))
)

function queryOnce<TContext>(config): Promise<InferResultType<TContext>>;

Defined in: packages/db/src/query/query-once.ts:68

Executes a one-shot query using a configuration object.

TContext extends Context

QueryOnceConfig<TContext>

Configuration object with the query function

Promise<InferResultType<TContext>>

A promise that resolves to an array of query results

const recentOrders = await queryOnce({
  query: (q) =>
    q.from({ order: ordersCollection })
     .orderBy(({ order }) => desc(order.createdAt))
     .limit(100),
})