Application that allows users to visually create PostgreSQL SELECT queries.
- Add/remove queries
- Change query names
- Hide/view query menu
- View queries as list
- Use queries as subqueries
- 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 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 table
- Change order of joins
- 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
The setup for front-end is described at client and back-end at server
MIT