1.1.0
What's Changed
- feat(jdbc): add RawQueryService for arbitrary SQL with routing and transaction support (#15, closes #4)
- feat(jdbc): add upsert support with INSERT ON CONFLICT (#16, closes #6)
New APIs
RawQueryService — execute arbitrary SQL while keeping connection routing and transaction management:
rawQueryService.queryOne(dbId, sql, params); // single row
rawQueryService.queryList(dbId, sql, params); // multiple rows
rawQueryService.execute(dbId, sql, params); // INSERT/UPDATE/DELETE in transactionCreationService.upsert() — INSERT ON CONFLICT with configurable conflict resolution:
var config = new UpsertConfig(List.of("email"), List.of("name", "age"));
creationService.upsert(dbId, schema, table, columns, data, config);
// DO NOTHING variant:
var doNothing = new UpsertConfig(List.of("email"), null);Full Changelog: 1.0.1...1.1.0