Feature request: add OpenTelemetry support

[cfbao]

(Optionally?) emit OpenTelemetry data, like is possible with some other packages (e.g. HttpClient, AWSSDK, Npgsql...)

Wouldn't mind trying my hands on it if it's desired.

[MichaCo]

This might be something for 2.0 I was actually thinking about removing all the logging I currently have, which is not really a good implementation, with something like that maybe.

If you want, feel free to pitch a design of how that would work / look like @cfbao