Support for Go 1.27 UUIDs #2636

Is your feature request related to a problem? Please describe.
Go has a uuid package as part of std lib since 1.27 https://pkg.go.dev/uuid
It would be great if pgtype.UUID can return a std lib uuid directly.

Describe the solution you'd like
I am currently updating my projects to remove the google/uuid dependency in favor of the std lib uuid. As the std lib uuid implementation does not include Valuer or Scanner implementations, it is a bit unwieldy to work with when used with pgx results. I need to implement some boiler code to convert the [16]byte into a std lib uuid.

Describe alternatives you've considered
None.

Additional context
None.