telemetry: db.operation.name should be the database SQL operation (e.g. INSERT)

[jatcwang]

#2480 (comment)

[iRevive]

We use QueryAnalyzer to derive the proper operation name. But since we do not have any proper default implementation, we fall back to the JDBC operation names.

The attribute recording logic was fixed in this PR: #2448

metadata.operationName.foreach { operationName =>
  builder.addOne(DbAttributes.DbOperationName, operationName)
}

---

Once the OpenTelemetry QueryAnalyzer is configured, the db.operation.name attribute will be correct: https://typelevel.org/doobie/docs/20-Otel4s-Tracing.html#opentelemetry-java-instrumentation.

[iRevive]

So, unless we reimplement OpenTelemetry QueryAnalyzer, we cannot get a meaningful operation name by default.

[jatcwang]

Thanks for clarifying @iRevive!