{
    "schema": "DDB_VISITS_SQL_STATIC_AUDIT_V1",
    "captured_at": "2026-07-26T05:33:14+02:00",
    "patterns": {
        "extract_year_predicates": 0,
        "trunc_date_predicates": 5,
        "database_fetch_all_calls": 14,
        "metadata_all_tab_columns": 1,
        "metadata_all_tables": 1,
        "safe_dataset_calls": 28
    },
    "observations": [
        "The Visits page uses one consolidated monthly OPD/Emergency bundle.",
        "Year-mode filters use direct half-open date ranges; EXTRACT is not used in WHERE predicates.",
        "Daily trend uses a direct date-column range and keeps TRUNC only for grouping/labels.",
        "Metadata discovery queries ALL_TAB_COLUMNS and ALL_TABLES.",
        "The controller loads all Visits datasets before rendering."
    ],
    "source_changes": "NONE",
    "oracle_writes": "NONE"
}