Nobody in their right mind is using BQ for oltp workloads

Yes, but in addition to being ACID compliant (serializable ANSI), you need to support a million transactions per second - it’s not just about data size.