Query Builder

Query Builder creates a SELECT statement from tables and views that use the active SQL or PL/SQL worksheet’s connection. Open a bound worksheet before launching Nexo SQL Studio: Open Query Builder.

Build a query

1. Drag tables or views from Connections Explorer onto the canvas, or choose Add tables.
2. Select the columns to include. Review inferred relationships and choose join types on the diagram.
3. Inspect the generated SQL in the preview. Edit or format the statement there, then run it or choose Insert into worksheet.

Query Builder keeps the worksheet connection attached to the query. To model a broader schema or export a diagram, see Data Modeler.