Hi
I've been playing with snippets for a while.
Thanks for this @thatjeffsmith-oracle for his detailed explanation in https://www.thatjeffsmith.com/archive/2024/03/adding-custom-snippets-in-vs-code-for-sql-developer/.
I have few comments about it:
description field seems not to be shown anywhere but replacing the first line with a description like this:
"select * from {table}": {
"prefix": "ssf",
"body": [
"select *",
"from ${0:table}",
";"
],
"description": "select * from"
},
Allows us to understand what the snippet is doing:
Another issue that is visible above, if I type ssf I would expect ssf to appear as first. Instead, any match of objects and snippets having the 3 letters S,S and F are shown in a different order. And if you have an abbreviation which matches many objects you may find your abbreviation at the very end. Not really useful to my opinion.
And still, I hope sooner or later, we will get the possibility to add the custom snippets to the snippets panel.