There are multiple responses to this suggestion.
Support for SQL-like syntax for UPDATE, DELETE and INSERT INTO are not on our road map at this time.
However, the underlying functionality for an UPDATE, SET is essentially a PATCH. This functionality we are actively working on. See this User Voice item here to track for future updates. https://feedback.azure.com/forums/263030-azure-cosmos-db/suggestions/6693091-be-able-to-do-partial-updates-on-document
Thank you for your suggestion.
An error occurred while saving the commentOliver Münchow (AixConcept GmbH) commented
Within the data explorer you can only filter the data but you can not simply update or delete data through the explorer. Would be great if you could write something like
delete from c where c.name = "Robert"
update c set c.name = "Paul" where c.name = "Robert"Oliver Münchow (AixConcept GmbH) supported this idea ·
3 votesOliver Münchow (AixConcept GmbH) shared this idea ·