¶Query Builder

The visual Query Builder assembles a SELECT without hand-writing SQL. Open it from the command palette (Query builder).

!!! info "Requires Pro" The Query Builder is a Pro feature.

¶Building a query

1. Add tables from the dropdown. Each table appears as a draggable node with its columns.
2. Tick columns to add them to the SELECT list (none ticked = SELECT *).
3. Joins are inferred from foreign keys: when you add a related table, an INNER JOIN … ON … is created automatically and drawn between the nodes.
4. Add an optional WHERE clause in the field below the canvas.

The generated SQL updates live at the bottom.

¶Using the result

• Open in query — send the SQL to a new query tab to run or tweak.
• Copy SQL — copy it to the clipboard.

!!! note Join detection uses the server's foreign-key metadata. Tables without a relationship are combined with CROSS JOIN; add a WHERE (or an explicit join in a query tab) as needed.