I do, too, but it’s truly not practically-possible for Amazon to do so, as our friend @lake explains in this 081326 SAS post (and related posts to the same thread):
That is because the function does not belong at the level it is being implemented at, and it does not work, The essence of why this problem is insoluble.
If there is not a distributed database, the record locking is solved at the level of the underlying file system. Which is a lower layer. The database and the application do not need to do anything.
Unfortunately, this problem keeps getting delegated to application programmers, who are plentiful, and have little knowledge of what is going on,…