SQL editor and formatter plugin use different ways of quoting keywords

[githubuser181226]

Hi.

Another weird thing with the code editor / formatter.

When using autocomplete to select keyword with spaces, the SQL editor puts it within double-quotes ie. "keyword with spaces".

However, as Format SQL button is clicked (or Ctrl+T is pressed) this suddenly gets replaced by square brackets ie. [keyword with spaces]

I don't really mind either way as long as the statement works, but I suspect this confusing behavior is not intended, or am I missing something?

I learned today the bracket notation is not really SQL standard one, merely a compatibility feature for SQL Access.

Can we perhaps have it so that the user can select explicitly for both - the SQL editor and SQL formatter to use either "keyword with spaces" or [keyword with spaces] and never switch from one to another?

I just want the program to stop confusing me with things it does :)

See attatched capture.
Thanks.

Could very well be related to #5347

5353.mp4

[pawelsalawa]

Go to this option and change it up to your preferences: