UUIDs as object identifiers (maybe string based?)

I know that there are some tickets around, but honestly, its quite annoying to not have this key feature of a database implemented. I saw, that there were some efforts in 2017 (thats 4 years ago btw.) but nothing changed since. So instead of only having Long as an id primary type, i also would like to have String and UUID. I know, that there are maybe some performance impacts with that, but that should not matter, since its the responsibility of the developer to choose the correct id types.

Use case scenario for UUIDs:
Distributed systems, where you identify your entity by its globally unique UUID, and you dont want to deal with internal system ids and the global UUID.

首先审查现有的主键和对象标识符支持，然后查找 issue 中引用的早期 ticket 和 2017 年的相关工作。范围需要确定 String 和 UUID 标识符应如何工作，以及适用哪些兼容性或性能约束。完成内容应包括双方认可的行为，以及对这两种标识符类型的覆盖。