Describe the problem

The code for these HTTP API handlers all use generateTableSpans(), which internally uses keys.TODOSQLCodec.
This is incorrect.

The helper function should instead receive the codec as argument, and the HTTP API handler should pass the ambient codec (the current one for the tenant) instead.

Expected behavior

Code path is tenant-agnostic and does not use keys.TODOSQLCodec.

Epic: CRDB-16704

Jira issue: CRDB-16705

SQL-O11Y Endpoint Migration Tracking Issue: #89429