SOQL (Salesforce Object Query Language) is used to search and access Salesforce Org’s data. The usage is very similar to SQL but this one is specifically built for Salesforce.
SELECT Id, Name FROM Account WHERE Name = 'Salesforce Binge'
Looking at the above SOQL query, it sure does look pretty slick. Anybody (even a rookie) can build this, isn’t it?
When to use SOQL?
A SOQL query may be used when one wants to retrieve data from one object/ one or more related objects. Considering what, where, and why is known.
Salesforce only allows fetching/accessing records from multiple objects only when they are related. However, SOQL does not support arbitrary join operations as you can do in SQL.