[internal/core] migrate semconv from v1.25.0

[codeboten]

Component(s)

internal/core

Describe the issue you're reporting

While removing usage of old semconv imports, i found that this package uses semantic conventions that rely on v1.25.0. Specifically the following attributes:

db.connection_string
db.user
net.host.port
net.peer.name
net.peer.port
net.transport
db.name
db.statement

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners for internal/core: @open-telemetry/collector-approvers. See Adding Labels via Comments if you do not have permissions to add labels yourself. For example, comment '/label priority:p2 -needs-triage' to set the priority and remove the needs-triage label.

[github-actions]

Pinging code owners:

• internal/core: @open-telemetry/collector-approvers

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