Result Filters (WHERE & ORDER)

After a query runs, the Result panel exposes two inline filters that let you narrow and sort results without touching the SQL editor. These operate on the data already loaded — they don't re-execute the query.

WHERE Filter

A filter bar above the result grid accepts a condition expression:

email LIKE '%@gmail.com'
status = 'active'
created_at > '2026-01-01'
amount >= 100 AND amount <= 500

The grid redraws live as you type. Results not matching the condition are hidden; the row count in the toolbar updates to reflect the filtered total.

Syntax

The WHERE filter uses the same expression syntax as SQL:

Clearing the Filter

Press Esc in the filter bar or click the × button to clear. The full result set is restored without re-running the query.

ORDER Filter

The ORDER filter controls the sort order of the result grid:

created_at DESC
name ASC, email ASC
amount DESC, created_at ASC

Multiple columns are supported separated by commas. Clicking a column header in the grid also sets the ORDER filter.

Combining Filters

WHERE and ORDER work together. The WHERE condition filters rows, ORDER sorts the filtered result. Both are applied client-side on the loaded page.

Keyboard Shortcuts

Exporting Filtered Results

The Export button exports only the rows matching the current WHERE filter — not the full result set. This lets you slice a large result and export a subset without modifying your SQL.