We want to remove uses of keysutils.TestingSQLCodec (previously keys.TODOSQLCodec) then remove that codec altogether.

Dependencies:

• Feature work:

  • table/db details in admin server HTTP API server: the TableDetails, TableStats, DatabaseDetails API don't decode with a proper tenant prefix #82879
  • cockroach debug backup export backupccl: debug backup export not tested (maybe not working) for tenant backups #82878
  • KV replication reports kvserver/reports: SREs can't use replication reports to check application of tenant zone configs #82881 - use renamed to FIXMEIDONTKNOWWHICHCODECTOUSE in *: identify remaining uses of TODOSQLCodec #99774

• Test code:

  • backup TestPublicIndexTableSpans, check two keyspaces backupccl: TestPublicIndexTableSpans should exercise secondary tenant keyspans #82882
  • tenant streaming TestRandomClientGeneration, plumb proper codec streamingest: TestRandomClientGeneration should use the proper SQLCodec in assertEqualKVs() #82883
  • columnar execution, TestSpanAssembler, check two keyspaces colexecspan: TestSpanAssembler should exercise guest tenant keyspaces #82884
  • row / jobs, TestJobBackedSeqChunkProvider, plumb proper codec sql/row: TestJobBackedSeqChunkProvider incorrectly uses keys.TODOSQLCodec #82886
  • keysutils/pretty_scanner (used by replication reports), plumb proper codec server: allow users to run conformance reports for their schemas #100004 / kvserver/reports: SREs can't use replication reports to check application of tenant zone configs #82881

Jira issue: CRDB-4356
Epic: CRDB-26091