manifold-sql: support batch processing

manifold-sql should provide a type-safe, well integrated API for batch processing.

Proposal:

Use addBatchChange to batch many invocations of the same parameterized statement as one database call.

List<String> countries = loadCountries)();
. . .
Sakila.addBatchChange(ctx -> {
  for(String country: countries) {
    "[.sql/] INSERT INTO country (country) VALUES (:name)".execute(ctx, country);
  }
}  
. . .
Sakila.commit();

Use addBatchChange to batch many non-parameterized SQL statements as one database call.

Sakila.addBatchChange(ctx -> {
    "[.sql/] INSERT INTO country (country) VALUES ('Canada')".execute(ctx);
    "[.sql/] INSERT INTO country (country) VALUES ('Mexico')".execute(ctx);
    "[.sql/] INSERT INTO country (country) VALUES ('Belize')".execute(ctx);
    . . .
  }
}
. . .
Sakila.commit();

manifold-systems / manifold

manifold-sql: support batch processing #607