The full form of SOQL is Salesforce Object Query Language. SOQL supports some features in SQL. SOQL is similar to SQL (Structures Query Language). By using SOQL in salesforce we fetch the data in force.com.

What are the SOQL features?

  • SOQL is case insensitive.
  • SOQL is very easy to understand when compared with SQL.
  • SOQL helps to optimize code.
  • SOQL reduces our workload and time.
  • Data from objects can be extracted to Excel sheets using SOQL.
  • SOQL queries will be required in APEX programming.
  • Wide knowledge in SOQL will help to be a good developer.

SOQL purpose.

  • Salesforce Object Query language in APEX statements.
  • In Visualforce Controllers and the getter methods.
  • In Schema Explorer of the Force.com IDE.

Salesforce Object Query Language(SOQL) is case insensitive which means we can write in Uppercase, Lowercase, and in both Lower and Uppercase. For our convenience in our Salesforce Developer Tutorials we us Uppercase for SOQL keywords and Lowercase letters for names, field lists, and conditions.

When SOQL is used we can optimize the code which results in faster execution of results. Data can be extracted from salesforce Custom objects and Standard Objects with the help of Salesforce Object Query Language(SOQL).

In SOQL we use API names of Standard and Custom Objects. Generally, Custom objects API name always ends with__c.