Visual Query Builder
The Visual Query Builder lets you create complex database queries by pointing and clicking—no SQL knowledge required.
Building Your Query
Adding Tables
- Click a table name in the left panel to add it to your canvas
- Drag tables to rearrange them
- Add multiple tables to create joins
Selecting Columns
- Check the columns you want in your results
- Click "Select All" for all columns from a table
- Uncheck columns you don't need
Joining Tables
- Drag a line from one column to another to create a join
- Right-click the join line to change join type (INNER, LEFT, RIGHT)
- Auto-detects relationships based on foreign keys
Adding Filters
- Click the filter icon next to any column
- Choose an operator (equals, contains, greater than, etc.)
- Enter your filter value
- Combine filters with AND/OR logic
Filter Operators
| Operator | Description | Example |
|---|---|---|
| Equals | Exact match | status = 'Active' |
| Contains | Partial text match | name contains 'Smith' |
| Between | Range of values | date between 1/1/24 and 12/31/24 |
| Is Null | Missing values | email is null |
Preview and Run
- Click Preview to see the first 100 rows
- Click View SQL to see the generated query
- Click Run Query to load all results into Excel