Query Builder is a visual editor for creating and managing SQL queries, such as SELECT, INSERT, UPDATE, and DELETE. Instead of writing SQL code manually, you can build queries by dragging SQL database objects, including tables, views, or user-defined functions, onto the Query Builder diagram.
You can build queries by using the visual diagram or by writing SQL code directly. Query Builder provides two synchronized panels: one displays the query as a diagram, and the other shows the corresponding SQL code. Any changes made in either panel are automatically reflected in the other, ensuring both views remain in sync.
You can modify queries by adding columns, defining joins, applying filters, grouping data, and sorting results in ascending or descending order. You can also use Query Builder to change query types, set aliases for tables and columns, and manage the diagram layout by aligning tables and joins.
You can build nested queries by creating subqueries in the WHERE, FROM, or SELECT clauses. The tool supports both unnamed subqueries for filtering and named subqueries for complex data transformations.
You can retrieve data with SELECT statements or build queries to update, insert, or delete records in the database. Query Builder supports all standard SQL operations and PostgreSQL-specific syntax.
After you create a query, you can run it and view or edit the results in the results grid.