Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.
Addresses the 999 variable limit in D1/SQLite by providing a pattern and utility functions to automatically batch database queries. This skill is critical when using Drizzle ORM for operations involving dynamic arrays, such as `inArray()` clauses or bulk inserts and updates. By intelligently chunking large operations with utilities like `autochunk`, it ensures your application remains stable and avoids runtime errors when dealing with unbounded datasets from user input or previous query results.
Key Features
010 GitHub stars
02Provides `autochunk` and `autochunkFirst` utilities for efficient sequential batching
03Manages dynamic arrays in `inArray()` clauses and bulk operations
04Supports parallel query execution using `chunk()` with `Promise.all`
05Automatically chunks queries to stay below the 999 SQL variable limit
06Calculates batch sizes dynamically, accounting for other bound parameters in the query
Use Cases
01Querying for a large, dynamically generated list of record IDs
02Performing bulk inserts, updates, or deletes with an unpredictable number of rows
03Fetching data based on unbounded user-generated lists, like team members or event registrations
