update-contact-both-fields

{
  "sql": "SELECT cust_id, first_name, last_name, email, phone FROM customers WHERE phone = '602-555-0117' OR email IS NULL"
}

{
  "rows": [],
  "row_count": 0,
  "truncated": false
}

{
  "sql": "SELECT cust_id, first_name, last_name, email, phone FROM customers LIMIT 10"
}

{
  "rows": [
    {
      "cust_id": "CUST-prospect-il-auto",
      "first_name": "Aaron",
      "last_name": "Halloway",
      "email": "aaron.halloway@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-nest-household",
      "first_name": "Marisol",
      "last_name": "Trujillo",
      "email": "marisol.trujillo@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-heritage-auto",
      "first_name": "Walter",
      "last_name": "Pennington",
      "email": "walter.pennington@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-ca-masked-auto",
      "first_name": "Priya",
      "last_name": "Anand",
      "email": "priya.anand@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-fl-coastal-home",
      "first_name": "Gloria",
      "last_name": "Esposito",
      "email": "gloria.esposito@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-legacy-mismatch",
      "first_name": "Raymond",
      "last_name": "Castillo",
      "email": "raymond.castillo@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-ne-auto-pref",
      "first_name": "Eleanor",
      "last_name": "Whitfield",
      "email": "eleanor.whitfield@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-se-auto-pref",
      "first_name": "Travis",
      "last_name": "Boudreaux",
      "email": "travis.boudreaux@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-legacy-unmigrated-auto",
      "first_name": "Doris",
      "last_name": "Maddox",
      "email": "doris.maddox@example.com",
      "phone": null
    },
    {
      "cust_id": "CUST-life-suitable",
      "first_name": "Eleanor",
      "last_name": "Whitmore",
      "email": "eleanor.whitmore@example.com",
      "phone": null
    }
  ],
  "row_count": 10,
  "truncated": false
}

{
  "sql": "SELECT cust_id, email, phone FROM customers WHERE first_name = 'Tanya' AND last_name = 'Brooks' AND email = 'tanya.brooks@example.com'"
}

{
  "rows": [
    {
      "cust_id": "CUST-retention-target",
      "email": "tanya.brooks@example.com",
      "phone": null
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "sql": "SELECT p.policy_id, p.status, pm.status as payment_status, pm.due, pm.amount_cents \nFROM policies p \nJOIN payments pm ON p.policy_id = pm.policy_id \nWHERE p.cust_id = 'CUST-retention-target' \nORDER BY pm.due DESC LIMIT 5"
}

{
  "rows": [
    {
      "policy_id": "POL-retention-target-p_auto",
      "status": "ACTIVE",
      "payment_status": "SCHEDULED",
      "due": "2025-06-01",
      "amount_cents": 7612
    },
    {
      "policy_id": "POL-retention-target-p_auto",
      "status": "ACTIVE",
      "payment_status": "PAID",
      "due": "2025-05-01",
      "amount_cents": 7612
    }
  ],
  "row_count": 2,
  "truncated": false
}

{
  "query": "autopay"
}

{
  "results": []
}

{
  "sql": "SELECT * FROM kb_documents WHERE body_md LIKE '%autopay%' OR title LIKE '%autopay%'"
}

{
  "rows": [],
  "row_count": 0,
  "truncated": false
}

{
  "sql": "SELECT * FROM kb_documents WHERE body_md LIKE '%bill%' OR title LIKE '%bill%'"
}

{
  "rows": [
    {
      "doc_id": "KB-LOYALTY-AUTHORITY",
      "title": "PineRewards points: what a service rep may post",
      "category": "POLICY",
      "applies_to": "{\"lines\": \"ALL\"}",
      "body_md": "Tiers (Seedling → Sprout → Timber → OldGrowth) are assigned annually from\ntenure and lifetime earning, **not** the current point balance. Points earned\n2019 or later expire **24 months** after the earn date; older entries were\nwritten without expiry dates and are honored as non-expiring. A service rep\nmay post exactly three kinds of manual ledger entry:\n\n1. **Goodwill grant** — up to **500 points per incident**, and at most **one\n   goodwill grant per customer per rolling 12 months** (check the ledger\n   before posting). Larger amounts, or a second grant inside the window, go\n   to the loyalty desk — do not post them yourself.\n2. **Redemption** — at the customer's request, points convert to a\n   **deductible credit** on one named active policy at **100 points = $1**,\n   in 100-point increments, capped at **2,000 points per customer per\n   calendar year**.\n3. **Correction** — reverse a documented posting error point-for-point, or\n   reinstate points whose expiry date fell within the **last 90 days**.\n   Older expiries go to the loyalty desk.\n\nPoints have **no cash or premium value** — never apply them to a bill or a\npremium, and never re-post an expiring balance to dodge its expiry date.\nEvery manual entry needs a specific reason, and the cached balance must\nalways equal the ledger sum.\n"
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "sql": "SELECT * FROM payments WHERE cust_id = 'CUST-retention-target' AND status = 'SCHEDULED'"
}

{
  "rows": [
    {
      "payment_id": "PMT-POL-retention-target-p_auto-1",
      "cust_id": "CUST-retention-target",
      "policy_id": "POL-retention-target-p_auto",
      "due": "2025-06-01",
      "paid_on": null,
      "amount_cents": 7612,
      "status": "SCHEDULED"
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "phone": "602-555-0117",
  "email": "tbrooks.az@example.com",
  "cust_id": "CUST-retention-target"
}

{
  "ok": true,
  "rows_affected": 1,
  "changeset": {
    "customers": {
      "changed": [
        {
          "pk": {
            "cust_id": "CUST-retention-target"
          },
          "fields": {
            "email": [
              "tanya.brooks@example.com",
              "tbrooks.az@example.com"
            ],
            "phone": [
              null,
              "602-555-0117"
            ]
          }
        }
      ]
    }
  }
}

{}

{
  "ok": true,
  "note": "Deliver your closing message now."
}