title: Azure Cosmos DB SQL API UPDATE statement - don't replace whole document
body: <p>Can I write an <code>UPDATE</code> statement for Azure Cosmos DB? The SQL API supports queries, but what about updates?</p>
  
  <p>In particular, I am looking to update documents without having to retrieve the whole document. I have the ID for the document and I know the exact path I want to update within the document. For example, say that my document is</p>
  
  <pre><code>{
    "id": "9e576f8b-146f-4e7f-a68f-14ef816e0e50",
    "name": "Fido",
    "weight": 35,
    "breed": "pomeranian",
    "diet": {
      "scoops": 3,
      "timesPerDay": 2
    }
  }
  </code></pre>
  
  <p>and I want to update <code>diet.timesPerDay</code> to 1 where the ID is <code>"9e576f8b-146f-4e7f-a68f-14ef816e0e50"</code>. Can I do that using the Azure SQL API without completely replacing the document?</p>