Application that allows users to visually create PostgreSQL SELECT, INSERT, UPDATE and DELETE queries.
The setup for front-end is described at client and back-end at server
- Add/remove queries
- Change query names
- Hide/view query menu
- View queries as list
- Use queries as subqueries
- Create INSERT statements
- Add singular or multiple value rows to database
- Use subquery to insert data
- RETURNING clause on individual columns or all
- Create UPDATE statements
- RETURNING clause on individual columns or all
- Join tables with FROM clause
- Add filter condition to column
- Create DELETE statements
- RETURNING clause on individual columns or all
- Join tables with USING clause
- Add filter condition to column
- View tables in a schema
- Switch schemas
- Search for tables
- Add/remove tables to/from query
- Add alias to table
- Copy tables
- Add/remove columns to/from query
- Add expressions
- Add alias to column
- Add aggregate function to column
- Add filter condition to column
- DISTINCT ON
- ORDER BY ASC/DESC
- GROUP BY
- Change order of columns
- Copy columns
- Switch between displaying and not displaying column in query
- Limit rows
- Link subqueries to filter
- Filter grouping results
- Combine multiple filters with operators
- Join tables
- Add multiple conditions to join
- Add/remove set operations
- Change order of set operations
- Find UNION/UNION ALL/INTERSECT/EXCPEPT between queries
- View built SQL
- Write queries manually or modify built SQL in editor
- Resize editor window
- Highlight matching brackets
- Syntax highlight for SQL clauses/statements
- Immediately see the number of results found
- Run the query and view the results
- Download generated SQL
- Download query results
- Delete all queries at once or one by one
- Change the language (English, Estonian)
- Refresh the page without losing the built query
- Save built queries for later use
- Download generated SQL code
- Download results as CSV files
MIT