Ensure db spans emit low-cardinality span names when span streaming is enabled.

Span name rules: https://getsentry.github.io/sentry-conventions/names/#db-queries

Fallback constant: DB_SPAN_NAME_FALLBACK in packages/core/src/tracing/spans/spanNames.ts

Part of #22350 — remember to check traceLifecycle and keep the existing name for static mode.