4.27When Query first still makes sense
Suppose requirements say:
Only update customers whose Salesforce Account has
Allow_External_Update__c = true.
Now:
Query
↓
inspect state
↓
Choice
↓
Upsert/Update
is completely justified.
Don't optimize API calls at the expense of required business behavior.