We discussed some of these problems here during a Postgres.tv session, and developed a patch to support ULID / UUIDv7: https://www.youtube.com/watch?v=YPq_hiOE-N8

And then Andrey proposed a patch in the pgsql-hackers mailing list: https://www.postgresql.org/message-id/flat/CAAhFRxitJv%3DyoG..., https://commitfest.postgresql.org/43/4388/

Everyone who can help (test, discuss, etc.) – please participate in that discussion.

The standard is not finalized yet, but there some expectations that it will be, if it happens, it would be great to have this in future Postgres 17.