You don't need anything specific. SELECT ... FROM queue FOR UPDATE SKIP LOCKED is the secret sauce.

Would be nice to get some goodies for free, like overview, pausing, state, statistics etc. :-)

This is exactly how pgmq is implemented, + the usage of VT.

https://www.jobrunr.io//en/ seems to be popular at the moment.

That looks pretty good! Too bad that the OSS version limits the number of jobs quite a bit.