Question: how is soql different from sql?
Answer: SOQL has no equivalent INSERT, UPDATE, and DELETE statements. In the Salesforce world, data manipulation is handled using a set of methods known as DML (Data Manipulation Language). ... In SOQL, you specify each field name to return. Beyond that, the SELECT statement that SOQL provides is similar to SQL.