SOQL Query Builder

Build Salesforce SOQL queries visually with field selection and filters

Query Builder2 fields

SELECT FROM

Fields(2 selected)

WHERE Conditions

No conditions added

Date Literals:

TODAYYESTERDAYTOMORROWLAST_WEEKTHIS_WEEKNEXT_WEEKLAST_MONTHTHIS_MONTH

ORDER BY

No ordering specified

LIMIT & OFFSET

LIMIT

OFFSET

Generated SOQL28 chars • 2 lines

1	SELECT Id, Name
2	FROM Account

About SOQL Query Builder

Build SOQL queries visually with field selection, WHERE conditions, ORDER BY, and LIMIT. Supports standard and custom Salesforce objects.

Frequently Asked Questions

What is SOQL?

SOQL (Salesforce Object Query Language) is the query language for Salesforce. It is similar to SQL but designed for Salesforce's object model. Used in Apex, APIs, and Developer Console.

How do I use date literals?

SOQL supports date literals like TODAY, YESTERDAY, THIS_MONTH, LAST_N_DAYS:30. Use them directly in WHERE clauses without quotes: CreatedDate > LAST_WEEK.

What is the maximum LIMIT in SOQL?

The maximum LIMIT is 50,000 records for SOQL. For OFFSET, the maximum is 2,000. Use LIMIT and OFFSET together for pagination.

SELECT FROM

Fields(2 selected)

WHERE Conditions

ORDER BY

LIMIT & OFFSET

About SOQL Query Builder

Frequently Asked Questions

What is SOQL?

How do I use date literals?

What is the maximum LIMIT in SOQL?

Related Tools

SELECT FROM

Fields(2 selected)

WHERE Conditions

ORDER BY

LIMIT & OFFSET