Default ready to use SELECT TOP query

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

Start by tracing the table context-menu entry point and the text-editor query insertion flow in the QuestDB Web Console. Check how table metadata and timestamp indexes are exposed before defining the menu options. Done means a table can generate a SELECT TOP-style query, with the requested ordering choices where supported, and insert it into the editor.