CI4 Database Pessimistic Locking Row

Well, if you know what you want to do with it - fair enough.

Though, I asked more about the "pessimistic" part, as a) pretty much nobody uses that term in PHPland; and b) it is wrongly described in the Laravel manual you linked to - a shared lock is not pessimistic.

Not sharedlock() but lockforupdate() as mention in laravel eloquent, "Prevent the rows from being modified or from being selected with another shared lock".

Keep calm.