Query Editor Enhancements

On Newest Version: 12.11.0.7074

Microsoft Windows 11 Business Version 10.0.26100 Build 26100

There are 2 enhancements that would be nice to the query editor:

1. When adding a . for searching for table names or columns, it would be good if when you clicked enter it removed the . from the start.

Example:

after hitting enter on Contact you get:

which means you have to go back and delete the . before Contact

2. Again when using the . it doesn't enclose column name in backticks ``

this would be useful as column names can contain hyphens (some of ours do) which when not enclosed in backticks throws an error

1. You are probably using the dot to trigger the proposal window. You should not do that. Just write: SELECT * FROM con and hit Ctrl + Space to trigger the completion proposal.

2. HeidiSQL encloses column names only if needed, to avoid quotes clutter in the editor. See this example where both column names were overtaken from the proposal, but only the second one needs backticks (due to a special character in its name):

SELECT * FROM feed_db d
WHERE d.Farbe=1 AND d.`Maße`=2;