Nice to see the KLR reference!
In MSSQL, you can do a BEGIN TRAN before your UPDATE statement.
Then if the number of affected rows is not about what you’d expect, doing a ROLLBACK would undo the changes.
If the number of affected rows did look about right, doing a COMMIT would make the changes permanent.
I’ve been replaying FO4 lately on console and so happy to have it now on PC to carry on trips.
I have the same question, mainly because it seems like the Plex interface is trying too hard to show stuff that’s not on my local server.