Intellisense improvement : Write the FROM automatically for the user based on the SELECT
The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking
For Example,
User types:
SELECT Master.Active,
Prompt now makes it
SELECT m.Active -- Cursor stays here
FROM Master m
We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.
Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.
This feature is also more natural to find because the developer will at some point type the table to get intellisense for the columns
and discover that Prompt took care of the rest.
We could even go a bit further and let Prompt write the join to a second table if there is only one foreign key to it (99% of the cases) :
User continuous typing with cursor at the same position
SELECT m.Active, Detail.Description
FROM Master m
Prompt now types:
User Types
SELECT Master.Active, d.Description
FROM Master m
JOIN Detail d ON d.MasterID = m.ID
A similar idea is described below but suggests to start with the FROM which does not feel natural
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/3986501-auto-complete-for-pk-column-values-example-sel
Tom Pester
shared this idea
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.
Please feel free to send us any additional feedback on these topics by commenting here.
Kind Regards,
The Prompt Team