Improve support for saved SQL queries / custom views

david@dalbert.net's profile image david@dalbert.net posted 2 years ago in General Permalink

Browsing/maintaining a database is probably the #1 application of HeidiSQL and the ability to more easily manage custom SQL queries would be hugely useful. The filtered data view is great, but very often, one needs a view that involves some relational joins...so some thoughts:

  1. Allow queries or custom (filtered) views to be created for a table and have them appear under the associated table in the tree viewer.

  2. An easier to implement (and still slick) solution would be to create a Documents/HeidiSQL/Queries folder and then add a node in the main tree view for the Queries folder and its named sub-folders.

I realize you can achieve much of this already using File->LoadSQL and creating your own folder hierarchy, but HeidiSQL is all about ease of use and elegance. The ability to easily find / execute saved queries from within the GUI seems like a significant enhancement.

ansgar's profile image ansgar posted 2 years ago Permalink

Please note there are also the query snippets, in the right side helpers box. I know that's not what you intend to ask for, but another way to organize your queries.

Please login to leave a reply, or register at first.