spacemacs 2024-11-24

when i load a sql file, i get an error about sql lsp. Even when i haven't been "trying" to use lsp with sql. When i lookinto the error it tells me to check the sql-ls buffer, when i look at that i get this:

/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/linkedMap.js:40
        return this._head?.value;
                          ^

SyntaxError: Unexpected token '.'
    at wrapSafe (internal/modules/cjs/loader.js:915:16)
    at Module._compile (internal/modules/cjs/loader.js:963:27)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
    at Module.load (internal/modules/cjs/loader.js:863:32)
    at Function.Module._load (internal/modules/cjs/loader.js:708:14)
    at Module.require (internal/modules/cjs/loader.js:887:19)
    at require (internal/modules/cjs/helpers.js:85:18)
    at Object.<anonymous> (/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/api.js:37:21)
    at Module._compile (internal/modules/cjs/loader.js:999:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)

Process sql-ls stderr finished
/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/linkedMap.js:40
        return this._head?.value;
                          ^

SyntaxError: Unexpected token '.'
    at wrapSafe (internal/modules/cjs/loader.js:915:16)
    at Module._compile (internal/modules/cjs/loader.js:963:27)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
    at Module.load (internal/modules/cjs/loader.js:863:32)
    at Function.Module._load (internal/modules/cjs/loader.js:708:14)
    at Module.require (internal/modules/cjs/loader.js:887:19)
    at require (internal/modules/cjs/helpers.js:85:18)
    at Object.<anonymous> (/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/api.js:37:21)
    at Module._compile (internal/modules/cjs/loader.js:999:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)

Process sql-ls stderr finished
/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/linkedMap.js:40
        return this._head?.value;
                          ^

SyntaxError: Unexpected token '.'
    at wrapSafe (internal/modules/cjs/loader.js:915:16)
    at Module._compile (internal/modules/cjs/loader.js:963:27)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)
    at Module.load (internal/modules/cjs/loader.js:863:32)
    at Function.Module._load (internal/modules/cjs/loader.js:708:14)
    at Module.require (internal/modules/cjs/loader.js:887:19)
    at require (internal/modules/cjs/helpers.js:85:18)
    at Object.<anonymous> (/home/drewverlee/emacs/spacemacs/.cache/lsp/npm/sql-language-server/lib/node_modules/sql-language-server/node_modules/vscode-languageserver/node_modules/vscode-jsonrpc/lib/common/api.js:37:21)
    at Module._compile (internal/modules/cjs/loader.js:999:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1027:10)

Process sql-ls stderr finished
I'm not even sure it's worth using LSP on sql atm, so i'm open to ideas about what to do about this? For instance, I could settle for not having this error and request to restart lsp happen everytime. Has anyone seen this before? What are you all using for editing SQL in spacemacs?

The https://develop.spacemacs.org/layers/+lang/sql/README.htmlhas a section on configuring LSP with SQLS (requires go), although I havent tried that myself. I assume the sql-langauge-server is the tool that Spacemacs installs by default. Note: I usually use DBeaver to write/run SQL rather than an editor