Investigate recipes for hidden board KPI metrics

Subtask of ALL-2479. Artem-requested evidence-only production-data investigation of devices.water_heater_count, alerts.unresolved_count, enrollments.pending_count, and programs.total_enrollments. Read-only production queries + schema/resolver trace; return exact recipe or minimal backend/stub recommendation.