Ensure multiple `Inputs` cache policies are consolidated when used in a `CompoundCachePolicy` #19470

Job	Run time
docker, python:3.9	5m 41s
docker, python:3.10	5m 12s
Server Tests - python:3.9, postgres:14	6m 26s
docker, python:3.11	5m 11s
Server Tests - python:3.10, postgres:14	6m 8s
docker, python:3.12	5m 12s
Server Tests - python:3.11, postgres:14	5m 24s
Server Tests - python:3.12, postgres:14	5m 49s
Server Tests - python:3.9, sqlite	6m 48s
Server Tests - python:3.10, sqlite	6m 39s
typesafety	2m 17s
Server Tests - python:3.11, sqlite	5m 56s
Server Tests - python:3.12, sqlite	6m 25s
Database and Orchestration Tests - python:3.9, postgres:14	7m 17s
Database and Orchestration Tests - python:3.10, postgres:14	7m 27s
Database and Orchestration Tests - python:3.11, postgres:14	6m 9s
Database and Orchestration Tests - python:3.12, postgres:14	6m 39s
Database and Orchestration Tests - python:3.9, sqlite	9m 22s
Database and Orchestration Tests - python:3.10, sqlite	9m 23s
Database and Orchestration Tests - python:3.11, sqlite	8m 1s
Database and Orchestration Tests - python:3.12, sqlite	8m 25s
Client Tests - python:3.9, postgres:14	10m 9s
Client Tests - python:3.10, postgres:14	9m 46s
Client Tests - python:3.11, postgres:14	8m 56s
Client Tests - python:3.12, postgres:14	9m 8s
Runner, Worker, Settings, Input, and CLI Tests - python:3.9, postgres:14	7m 2s
Runner, Worker, Settings, Input, and CLI Tests - python:3.10, postgres:14	6m 55s
Runner, Worker, Settings, Input, and CLI Tests - python:3.11, postgres:14	5m 52s
Runner, Worker, Settings, Input, and CLI Tests - python:3.12, postgres:14	6m 32s
	3h 20m 11s

Provide feedback