Smart Filters
Filter query results client-side with a visual filter builder — no re-running SQL
Smart Filters
Smart Filters let you narrow down query results without rewriting SQL. Filters run client-side on already-fetched data.
That’s the whole point: once you’ve pulled a result set, you can slice it a dozen different ways instantly — no round trip to the database, no editing your WHERE clause, no losing your place. It turns a static grid into something you can interrogate the way you’d filter a spreadsheet, which is perfect for exploring unfamiliar data or hunting down the handful of rows that look wrong.
Adding a Filter
- Click the filter icon in the results toolbar
- Select a column from the dropdown
- Choose an operator
- Enter a value
- The filter is applied immediately as a chip
Filter Operators
Text Columns
| Operator | Description |
|---|---|
| contains | Substring match |
| equals | Exact match |
| starts with | Prefix match |
| ends with | Suffix match |
| is empty | NULL or empty string |
| is not empty | Has a value |
Numeric Columns
| Operator | Description |
|---|---|
= | Equal to |
!= | Not equal to |
> | Greater than |
>= | Greater than or equal |
< | Less than |
<= | Less than or equal |
| between | Range (two values) |
| is empty | NULL |
Date Columns
| Operator | Description |
|---|---|
| equals | Exact date match |
| before | Earlier than date |
| after | Later than date |
| between | Date range |
| is empty | NULL |
Boolean Columns
| Operator | Description |
|---|---|
| is true | Value is true |
| is false | Value is false |
| is empty | NULL |
Stacking Filters
Add multiple filter chips to narrow results further. All filters are combined with AND logic.
Removing Filters
Click the X on any filter chip to remove it, or click Clear All to remove all filters.
Example: isolating a suspicious subset
You ran SELECT * FROM users and something’s off with free-plan signups. Instead of editing the query, add two chips: plan equals free, then email contains test. The grid narrows immediately to the rows that match both (filters stack with AND), and Column Statistics on the filtered view tells you how many you’re dealing with. Clear the chips and the full result is back — the underlying query never re-ran.
Smart Filters work on the rows already fetched, so they’re instant but bounded
by your result set — if a query has a LIMIT, you’re filtering only those
rows. When you need to filter the whole table, add a WHERE clause in the
Query Editor instead.
Related
- Results Viewer — the grid these filters run on
- Column Statistics — profile the rows a filter surfaced
- Query Editor — push a filter server-side with
WHERE