[Feature]: DynamoDB operations as database metrics

[Thorleon]

Component

Instrumentation: otelaws

Problem Statement

Currently, the DynamoDB instrumentation doesn't produce any custom metrics. However, OpenTelemetry provides specific metric definitions for database operations: https://opentelemetry.io/docs/specs/semconv/database/database-metrics/.
db.client.operation.duration is defined as both stable and required.

Other services, such as SQS or SNS, also lack type-specific metrics. However, their semantic conventions are still in the development phase, so I suggest focusing on the db metric first.

If there is consensus on adding this metric, I would be happy to implement it in my spare time.

Proposed Solution

Currently

Alternatives

No response

Prior Art

Java version of OTEL has implemented open-telemetry/opentelemetry-java-instrumentation#13033 or open-telemetry/opentelemetry-java-instrumentation#13283

Additional Context

No response