{
  "$schema": "https://json.schemastore.org/sarif-2.1.0.json",
  "runs": [
    {
      "results": [
        {
          "level": "note",
          "locations": [
            {
              "physicalLocation": {
                "artifactLocation": {
                  "uri": "database://loyalty/usp_reconcile_loyalty_customer"
                }
              }
            }
          ],
          "message": {
            "text": "Review generated convert migration fix."
          },
          "properties": {
            "confidence": "HIGH"
          },
          "ruleId": "changeproof/convert"
        },
        {
          "level": "warning",
          "locations": [
            {
              "physicalLocation": {
                "artifactLocation": {
                  "uri": "database://operations/usp_match_regional_returns"
                }
              }
            }
          ],
          "message": {
            "text": "Verify both join operands are BIGINT before changing the source."
          },
          "properties": {
            "confidence": "MEDIUM"
          },
          "ruleId": "changeproof/join"
        },
        {
          "level": "note",
          "locations": [
            {
              "physicalLocation": {
                "artifactLocation": {
                  "uri": "database://finance/vw_customer_revenue_bridge"
                }
              }
            }
          ],
          "message": {
            "text": "Review generated cast migration fix."
          },
          "properties": {
            "confidence": "HIGH"
          },
          "ruleId": "changeproof/cast"
        },
        {
          "level": "warning",
          "locations": [
            {
              "physicalLocation": {
                "artifactLocation": {
                  "uri": "database://exports/usp_export_customer_segments"
                }
              }
            }
          ],
          "message": {
            "text": "Contains dynamic SQL, so the referenced object and runtime type need manual review."
          },
          "properties": {
            "confidence": "LOW"
          },
          "ruleId": "changeproof/dynamic_sql"
        }
      ],
      "tool": {
        "driver": {
          "name": "contextIsKey",
          "version": "0.1.0"
        }
      }
    }
  ],
  "version": "2.1.0"
}