18.12Scenario 11 — Incremental SOQL

Prompt:

“Get Accounts changed since the previous synchronization.”

SELECT
    Id,
    Name,
    External_Customer_ID__c,
    LastModifiedDate
FROM Account
WHERE LastModifiedDate > :watermark
ORDER BY LastModifiedDate

Then immediately say:

“I'd also think about equal timestamps, crashes and watermark advancement. I usually prefer a small overlap plus idempotent processing rather than assuming a perfectly gapless timestamp boundary.”

That turns a simple SQL question into a senior answer.