[feature request] SqlClient Spans Should Always Capture Comments in db.statement

[RogueMaurice]

Component

OpenTelemetry.Instrumentation.SqlClient

Is your feature request related to a problem?

When using .NET 9 and EntityFrameworkCore, command text recorded in traces does not include comments add via DbCommandInterceptor.

What is the expected behavior?

When using .Net Framework 4.8 and EntityFramework6 command text recorded in traces shows comments added via DbCommandInterceptor.

I would like to have the full command text (minus whatever is redacted) available in every runtime that is supported by SqlClient or EntityFrameworkCore instrumentation.

Which alternative solutions or features have you considered?

None.

Additional context

No response

[wss-rbrennan]

db.statement is deprecated. https://opentelemetry.io/docs/specs/semconv/attributes-registry/db/#db-statement

[RogueMaurice]

When opting into the new semantics, db.query.text still does not display any comments. It appears that the command text is captured before code from any EF DbCommandInterceptor is executed.