BigQuery Optimistic Concurrency with DML: Upserts Without Deadlocks

Build “first writer wins” upserts that stay fast under load — without row locks, connection pileups, or the deadlock folklore you brought…