function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AnantGargAnantGarg 

Why isn't there a direct update DML operation allowed in SOQL?

What's the specific reason for not having an UPDATE query option in SOQL? 
We know there are many limitations of SQL over data limit, though a direct UPDATE operation on a table is allowed there. Like -  UPDATE TABLE TABLE_NAME, though in case of SOQL we need to first prepare the sObject then update its index.
Naveen KNNaveen KN
There is a complete explanation of why Salesforce has come up with a customer-facing data model on the top of SQL. Please go through the details here https://developer.salesforce.com/blogs/developer-relations/2017/03/soql-sql-developer.html

--
Naveen K N