How to comment out clauses in the Toad Data Point query builder

Hi, I'm going to go over a new commenting feature that's new to Toad Data Point 3.6 So when you're working on a query in the Query Builder, you might want to keep a filter or column that you have existing and maybe try out a variation. Right now, I have an in_condition on region name. What I can do is right-click and say, comment out this WHERE clause. And come up here and say, add to output. This gives me the same column. And I actually can come in here and change this. I can go ahead and execute that. Now I also can comment out a column if I like. I can just say, comment out this column. And that comes over here and comments out that column. You can also see the commenting of the WHERE clause that I did earlier. And we can un-comment these items and put them back also. Let's say that I want to put it back to my original query. And this is especially helpful when you're trying to build a ResultSet kind of incrementally. Now you could find out which SQL statement went with each ResultSet by coming down to this little Widget down here and clicking on this. This will show you, per ResultSets, what the query was that executed this one. And conversely, you can do the same for the other ResultSets. You can right-click also and compare one ResultSet to another. And this will help you see how your WHERE conditions actually changed. Now, using this commented-out feature is especially useful when you're working with other team members. If you keep a library of Query Builder files, you can bring a new team member up to speed pretty quickly by giving them one of the query finals and say, OK, this query is similar to what you want to be doing, just change the WHERE condition a bit. And they can learn about the new schema and build reports quicker by using it like a template. Now you can come in here and edit things manually. If you want to do that, you do need to click on this "visualize statement", this syncs it together. But when you do that, it puts everything into a global WHERE clause. So personally, I like to just use the comment in here from the UI. I find that to work quite well and very hearty. So there you go. New feature of commenting in the Query Builder.