I'm very excited for future development of SQL Prompt within ADS. I've been using SQL Prompt since it was PromptSQL in Query Analyzer. I'm happy to ditch SSMS as it has always been slow, bulky, and frequently freezes. The lightweight, text edit/keyboard focus of ADS is exactly what I'm looking for.
The built-in Snippet engine is great. I don't see a need for enhancement. The SQL Prompt snippet import is nice, but a little buggy. And honestly it's more of a 1 time thing since once I'm set up, I'm done.
The built-in Peek definition for objects is also adequate. It's not as nice as the various informational overlays SQL Prompt provides, but it gets the job done. I do miss how SQL Prompt smart caches everything so the information display is instant instead of a .5 - 2s delay.
The built-in autocomplete is decent. It does basic table/view/column/variables/table variable/temp tables pretty well. One feature I miss here is preferencing JOIN conditions based on FK relations and/or matching data types.
Probably my biggest wish is the "as you type" features like capitalization, qualification, table/column aliases, quote/bracketing, expand *. Anything to make the SQL exactly how I want it with minimum keystrokes is a plus.
In the formatting space, I don't use full formatting that often since I can't seem to get the rules to express my exact preferences. However, I frequently execute operations like capitalize, add/remove brackets, qualify/unqualify, especially on selected text.
Automatically adding the template after INSERT TABLE is a huge help. Also highlighting corresponding column/values when your cursor is on one or the other is very helpful.
Lastly I do use the "Inline Exec" feature a lot (I requested it for SQL Prompt)
0 · Share on Twitter