Query Builder built into dbForge Studio provides a graphical user interface to create SQL queries, such as SELECT, INSERT, UPDATE, and DELETE, by dragging the tables, views, and their columns on the Query Builder diagram instead of manually writing SQL code.
The tool helps you perform the following tasks:
Work with graphical queries or SQL code
Query Builder provides two synchronized panes: one displays the query as a diagram, and the other shows the corresponding SQL code. You can work in either pane–changes made in one are automatically reflected in the other, ensuring both views stay in sync.
Join related tables
When you add multiple tables to a query, Query Builder automatically determines their relationships and creates the appropriate joins.
Query and update databases
You can use the tool to retrieve data with SELECT statements or to build queries that update, insert, or delete records in the database.
View and edit results
After you run a query, the results appear in a grid where you can review and edit records directly in the database.