I do not think Sql Prompt should include the ability to add JOINs to your SQL as you are typing. (Or add the table names while adding fields to the SELECT clause).
I base this off of non-stop use of the Beta for the past few weeks.
I know the final version of SqlPrompt will behave differently then the beta, but as it is now I find myself fixing a lot of code that Sql Prompt 'helped' me write.
Sql Prompt should help me write my query -- it shouldn't do the writing for me. The more it tries to automate, the more likely it is to automate it incorrectly.
If you are looking for an easy way to build queries w/o writing your JOINs or FROM statements, use the "Design in Query Editor" tool.
Sql Prompt should be more like "cruise control" in a car and less like KITT from Knight Rider.
I base this off of non-stop use of the Beta for the past few weeks.
I know the final version of SqlPrompt will behave differently then the beta, but as it is now I find myself fixing a lot of code that Sql Prompt 'helped' me write.
Sql Prompt should help me write my query -- it shouldn't do the writing for me. The more it tries to automate, the more likely it is to automate it incorrectly.
If you are looking for an easy way to build queries w/o writing your JOINs or FROM statements, use the "Design in Query Editor" tool.
Sql Prompt should be more like "cruise control" in a car and less like KITT from Knight Rider.