The problem is that most postgres clients can't handle multiple parametric queries in a single connection (necessary for them to be in a single transaction).

This came to light for me as I was trying to build an app on CockroachDB, and the cluster nature of that (at least for geo-redundant setups) implies a non-negligible latency in the low single digits.