Oh yes. While "FOR UPDATE" seems to be consistent across various databases as mentioned above, they can have different variants for more specific cases. That is why the patch allows the user to pass a string override in the lock variable. This allows pgsql users to use the alternate "FOR SHARE" option and mysql users to use the equivalent "LOCK IN SHARE MODE", etc.
Oh yes. While "FOR UPDATE" seems to be consistent across various databases as mentioned above, they can have different variants for more specific cases. That is why the patch allows the user to pass a string override in the lock variable. This allows pgsql users to use the alternate "FOR SHARE" option and mysql users to use the equivalent "LOCK IN SHARE MODE", etc.