search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.9k stars 131 forks source link

Allow specific query execution #866

Open ccrvlh opened 2 months ago

ccrvlh commented 2 months ago

Currently, the query tab only allows execution of all queries (eg. separated by ;) within the same window. IMHO Postico has a very nice way of handling this - the query tab allows for multiple statements, and you are within a statement (cursor somewhere within a specific statement), the statement is slightly highlighted and you can just run that specific statement. As a user, most of the times I have multiple queries and usually just want to run one of them, and I do using the shortcut for execution (CMD + Enter on macOS).

Currently, I'd have to have multiple query tabs which forces the user to (1) have a single statement per tab and (2) manage several tabs with simple queries each.

The feature request is two fold:

  1. Allow for "statement-aware" query execution
  2. Allow for "statement-aware" execution shortcut

Would be happy to contribute to this.

Thanks!

Fabio286 commented 2 months ago

Hi @ccrvlh ,

by now to achieve this in Antares you have to select the desired query and press run (or F5). image

ccrvlh commented 2 months ago

@Fabio286 thanks for sharing, I did notice this behavior.

The main difference is that this requires the user to select the range, rather than the system understanding the statement context based on the cursor position - Postico has a slight highlight on the statement which helps to understand the context.

As for the shortcut, it can be edited, so not really relevant.

bart-schaefer commented 2 months ago

Possibly related, #832 includes the request

Execute query with right click context menu in query editor

Fabio286 commented 2 months ago

It has also been requested by other people in the past if I remember correctly. It seems trivial but with the editor library used (Ace Editor) it is not so easy to get the line the cursor is on. I will still try to look at it again.