Skip to main content
The SQL Assistant can help you build complex SQL queries for your database. It’s useful when utilizing the Direct Database Query function, or when you need to build a query that isn’t supported by the visual Query All Records function.

​
Using the SQL Assistant

1

Find the SQL Assistant

sql-assistant-20251011-083958

You'll find the SQL Assistant in the top-right corner of the Direct Database Query function.

2

Tell the Assistant about the query you're trying to build

The Assistant has access to your database (as long as you’ve accepted the A.I. Assistant terms and conditions), so it can understand queries like “get me all the records from the users table where the age is greater than 30” or “get me all the records from the users table who have placed orders in the last 30 days”.You can also ask the Assistant to build a query from scratch, or to modify an existing query.
3

Review and Iterate

Once the Assistant has taken a first pass at your question, you can continue to converse with it to iterate and expand, or correct missteps.
⌘I