Use this template for new query units to keep the repository LLM-friendly and auditable.
- ID: TX000 (or MV000 / PID000 / REF000)
- Status: active | deprecated | experimental
- Canonical: true | false
- Source of Truth: path/to/source_file.py:symbol
- Last Verified: YYYY-MM-DD
Describe what this query answers in one or two lines.
-- Place SQL query here- Primary tables:
- Key filters:
- Required assumptions:
- Expected columns:
- Typical row cardinality:
- Sanity check query:
- Known caveats:
- Links to other IDs or docs.