Support for Go 1.27 UUIDs

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.