The extension automatically add a .vscode/settings.json at the root level of the opened workspace:
{
"editor.acceptSuggestionOnEnter": true,
"editor.quickSuggestions": {
"other": false,
"comments": false,
"strings": false
},
"editor.quickSuggestionsDelay": 300,
}
These settings apply to the entire workspace including files that are not related to the SQLMesh project. For instance in my workspace there are others folder (analytics, ingestion) containing Python, R and other language code affected by those settings.
Solution: Add an SQL language specifier
{
"[sql]": {
"editor.acceptSuggestionOnEnter": "on",
"editor.quickSuggestions": {
"other": false,
"comments": false,
"strings": false
}
}
}
It doesn't solve the underlying issue but settings.json doesn't support sub-folder settings aside multi-workspace (which would add complexity).