Now you're reaching into unrelated areas... The DB does not need to be SINGLE-USER at all, the DB is locked by the statement itself, or by a transaction. If changes can happen out of band, then `RETURNING` or separate statements to fetch that same data *after the fact* are no better or worse. Completely orthogonal.