In some circumstances (like high volume of requests) the `MERGE` statement is not suitable and will run into race conditions.