Default ready to use SELECT TOP query #331
Description
Is your feature request related to a problem?
We think that one of the common operations users/developers want to execute on the database during developing phases, but also on production, is a fast view of table records. At the moment we need to rewrite always the same base query that is always:
SELECT * FROM my_beautiful_table. And then add something like "ORDER BY timestamp DESC".
This is a little bit annoying compared to other databases GUI clients.
Describe the solution you'd like.
We would like to have a new item in every table context menu like "Select TOP 1000 rows" (like Microsoft MSSQL) or "View Data" (like DBeaver). That can simply generate the query and add it to the text editor.
The additional feature could be having two more options when a table have a timestamp index that permits to select first top n items in ascending or descending order.
Describe alternatives you've considered.
No response
Full Name:
Enrico Benedos
Affiliation:
Deimos
Additional context
No response