Function allAllShards

allAllShards<T = Record<string, unknown>>(
    sql: string,
    bindings?: any[],
    batchSize?: number,
    options?: ReadOptions,
): Promise<QueryResult<T>[]>
Executes a query on all shards and returns all matching records from each shard.

This function is useful for scenarios where you need to retrieve all records matching a query across multiple shards, such as aggregating data or running cross-shard analytics.
Type Parameters
- T = Record<string, unknown>
Parameters
- sql: string
  The SQL statement to execute on each shard
- bindings: any[] = []
  Parameter values to bind to the SQL statement
- batchSize: number = 50
  Number of concurrent queries to run at once (default: 50)
- Optionaloptions: ReadOptions
  Read guarantee for this call. Each result carries its shard's bookmark on meta.bookmark, in config.shards order
Returns Promise<QueryResult<T>[]>
Promise resolving to an array of results from each shard

Since
1.0.4
- Defined in src/router.ts:3880