cweijan / vscode-database-client

Database Client For Visual Studio Code
https://database-client.com
MIT License
2.48k stars 283 forks source link

Suppress escaping for field names #761

Closed ptyork closed 1 year ago

ptyork commented 1 year ago

Related to https://github.com/cweijan/vscode-database-client/issues/696, but in reverse. Right now, the default behavior when accepting a mixed-case column name suggestion using intellisense is that it is wrapped/escaped in back-ticks.

As with the table names, can you by default suppress these unless the "escape all object names" option is selected? Or perhaps have another option to suppress escaping of field names? It's not a huge deal, but I think most RDBMS' are case insensitive for fields by default, and as you noted in the referenced issue, escaping makes SQL ugly. :)

ptyork commented 1 year ago

Uugh. A little more searching and I found it. You have to step into the "full" extension settings and select "never" (the main settings page just has a checkbox). I'll close this, though I guess a minor request would be to surface this option in the main extension settings dialog. Or perhaps to have it be the default?