BulkInsertBuilder class

Builder for creating bulk insert data buffers.

Provides a fluent API to define table structure, columns, and rows for efficient bulk insert operations. build returns a Uint8List that can be passed straight to bulkInsert / bulkInsertParallel without an extra copy.

Prefer columnar addColumnInt32 / addColumnInt64 / addColumnText when source data is already column-shaped (medium and large batches).

Rows passed to addRow are stored by reference; do not mutate a row list after it is added (wrap with List.unmodifiable when the same list instance might be reused elsewhere).

Row-oriented example:

final builder = BulkInsertBuilder()
  ..table('users')
  ..addColumn('id', BulkColumnType.i32)
  ..addColumn('name', BulkColumnType.text, maxLen: 100)
  ..addRow([1, 'Alice'])
  ..addRow([2, 'Bob']);
final buffer = builder.build();

Columnar example (avoids per-row List<dynamic> and bulk-copies fixed-width primitives):

final builder = BulkInsertBuilder()
  ..table('users')
  ..addColumnInt32('id', Int32List.fromList([1, 2]))
  ..addColumnText('name', ['Alice', 'Bob'], maxLen: 100);
final buffer = builder.build();