Notwithstanding this sort of thing being a good idea or not, the web framework developers should be addressing their defective usage of transactions and fixing them. That is to say that the solution to the problem of the water coming out of your hot water tap being "not hot enough" is not to "install a great big heater in the lake from which the water is drawn" but rather to fix your own water heater and plumbing. While the default transaction type for unadorned BEGIN commands is DEFERRED, this has been the case for almost half a century. Children implementing "web frameworks" have no excuse for not knowing this state of affairs that has existed since they were merely a gleam in their daddy's eye any more than they have an excuse for not knowing that water is wet.