sqlqueryreceiver does not support histogram metric types

[zdelagrange]

Component(s)

receiver/sqlquery

Is your feature request related to a problem? Please describe.

the sqlquery receiver does not support histogram data types.

Describe the solution you'd like

I would like to be able to create histograms from sql queryies, for example the datadog snowflake receiver supports a histogram datatype, where it creates *.avg *.count *.max *95percentile *.max *.median from a query

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

Pinging code owners:

• receiver/sqlquery: @dmitryax @pmcollins

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

Pinging code owners:

• receiver/sqlquery: @dmitryax @crobert-1

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[crobert-1]

I think this is a valid request. Any PRs to add support for this would be welcome!