SOQL

SOQL is Salesforce's SQL-like query language for retrieving records from objects. It supports JOIN-like relationship traversal but lacks generic JOINs and aggregate functions are limited compared to standard SQL.