Execute SQL Queries Window: Updated
Data geeks: You already know how powerful that Execute SQL Queries window is, right? You know, the one you see in Tools, Commands, SQL Tools (if your client administrator has had it turned on for you), which lets you code right in your live production database so that you can pull your data using the SQL declarative programming language.
You didn’t know you could do that? Shucks – now is a great time to get started – and in our recent software deployment we’ve made that tool even better. In the March release, we added a check queries feature prominently, so that you can test your code before you have it run in the database. Using the Check Queries feature will help you debug any issues with your code before you run it – which gets you your data faster.
We also added a feature — view active queries — that lets you see queries that you have running. So, if you run another, smarter query, the original query might be running behind the scenes. This feature allows you to cancel that un-needed query.