Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words. "Status", "Type",etc.",
Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
"Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.
How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
We only have the following settings:
a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES, remove unnecessary brackets = YES (our desired result)
BUT, we do not want the square brackets removed from BLUE special syntax highlighted words, of course. How to do this?
(In SQL Prompt the "remove unnecessary brackets" setting means it'll remove all the brackets that aren't needed to run the script. If you had a fully reserved keyword like While or Table, then the brackets around it would be necessary to run the script.)