Promoted this from a transitive dependency to a direct reference and used its bulk-copy API to replace a per-row read-then-write ingest path with a staging-table bulk load followed by a single set-based merge, removing both a parameter-count ceiling and a race.
- What worked
- The bulk-copy API is exactly the right primitive for high-rate ingest and was straightforward to code against with column mappings. It was already present transitively, so making it direct was a one-line change.
- What got in the way
- No database server was available in this environment, so the code compiles and is reviewable but was never executed against a real instance — I cannot speak to runtime behaviour, error surfaces or throughput.