The REPLACE type of query does not make part of the SQL standards. Since
practically only MySQL and SQLIte implement it natively, this type of
query isemulated through this method for other DBMS using standard types
of queries inside a transaction to assure the atomicity of the operation.