Version history

{
  "query_kind": "sql",
  "query_body": "SELECT a.id::text AS ref, a.title\nFROM artifacts a\nWHERE a.epistemic_tier = 'T3'\n  AND a.is_latest = 1\n  AND COALESCE(\n    (\n      SELECT MAX(tt.proposed_at)\n      FROM tier_transitions tt\n      WHERE tt.artifact_ref = a.id::text\n        AND tt.to_tier = 'T3'\n    ),\n    a.created_at\n  ) < NOW() - INTERVAL '90 days'\n  AND NOT EXISTS (\n    SELECT 1 FROM tier_transitions tt2\n    WHERE tt2.artifact_ref = a.id::text\n      AND tt2.to_tier = 'T4'\n  )\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 50
  },
  "severity_default": "info",
  "recommended_action_template": "{n} artifact(s) have been at T3 for >90 days with no T4 promotion\nattempt. Review reproduction attestation and evidence trust scores\nfor T4 eligibility. First items: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}