Allow starting with FROM clause first to make intellisense and query building more natural
Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If GROUP BY, HAVING, WHERE or ORDER BY are in the wrong place, why not prompt to correct the syntax? Oh how lazyness can serve as mother of invention!
Dwaine Wright
shared this idea
Thank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Randel Bjorkquist
commented
Hi Thomas,
I have a similar idea to Tom's. I honesty didn't see his before I wrote mine. However, mine is a bit different in that my suggestion starts with the FROM statement, and uses a translation layer, which could be used for many different things, like different export formats.
http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/7069234-linq-style-sql
I'm very interested in your thoughts and comments on my idea. I only wish I knew the blog would remove all the leading whitespaces. I would have added a leading character to help format my SQL examples.
-
Thomas Franz commented
You could make a snipped 'sel' that expands to 'select * from '.
This way you would type 'sel table1' and get 'select * from table1' where all the intellisense works.
-
Tom Pester
commented
Hello Dwaine,
I have a similar idea but still start with the SELECT
Maybe we can think together about this?