Default ready to use SELECT TOP query

[enricobenedos]

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

[nwoolmer]

Hi @enricobenedos ,

You can get a similiar effect with table_name LIMIT -1000. This will give you the last 1000 rows, but sorted in ascending order.

In general, any query which is just a simple SELECT * FROM can have that part of the clause omitted. The table_name implicitly represents the table with SELECT * FROM in front.

In the meantime, I'll shift this to the UI repo since it is solely a UI change!

[enricobenedos]

Thank you @nwoolmer

Mine is only a suggestion because during the week, me and my colleagues, rewrite always the same stuff that we don't need to do with other clients . The most common thing to do before write the real query is always the same stupid select to take a look at the data 🥲