snippets, along with other sql prompt features

[bjwellsi]

in redgate you can do things like ii[tab] to get insert into, and then when you type the table name it'll expand out the fields in the field name section, and then put in blank values for each field. Very useful.

I have custom snippets that can turn ii[tab] into insert into table (fields) values (values), but it'd be great if there was a way to recognize inserts and expand out the fields automatically.

same with exec. when I select the sproc I'd love if I could get an auto expansion of the params. similar to #37

[Kurren123]

Cool feature. Can VS code do this?

[krixgris]

This is a typical thing a LS would be able to handle, but the Microsoft SQL LS doesn't do this, so this doesn't work in VSCode without the Redgate plugin suite (not even sure this is in VSCode or just in ADS or SSMS).

Sidenote, but I am trying to make a companion LS for things that the MS one doesn't do, like this, but time is scarce 😄

[Kurren123]

@krixgris If you are adept at csharp, this is a great library for making LSP's. Saying that, if your time is short then you might be better off with smaller side projects, an LSP is a big undertaking!

I'm closing this for now as if the LSP doesn't do this then it would likely be quite a bit of work, and we aren't close to feature parity yet with vscode. By all means if someone else wants to take this, let me know and I'll reopen this.

[krixgris]

@Kurren123 I am passable in C#.
Rust is what I mostly focus on now, and I have the basic parts of the LSP in place in Rust.
I can send and receive what I need. I just didn't start work on the file analysis yet, which is where most of the work is, and that's why I haven't had time to do more.
I mostly got into it to learn how the protocol works.