[7.0.132 beta] FR - lazy/greedy select current statement

[7.0.132 beta] FR - lazy/greedy select current statement

There's a hotkey to select current statement (the statement which the cursor is currently in). That an excellent feature I could use much more if it had a switch that could choose between "lazy" and "greedy" selection of the current statement.

What do I mean by that?

Right now if the cursor is in a SELECT subquery of a SELECT query that does an INSERT into a table the whole INSERT - SELECT - subSELECT gets selected. Most of the times I only want to test the SELECT or the subSELECT statement only and I have to select the statement manually. The "lazy" version could select the statement "downwards", that is, everything levels down the cursor position, selecting only the subquery if the cursor is there, or the complete SELECT with its subqueries if the cursor is there, etc., while the "greedy" could do the "upward" selection (all the way up to the INSERT part included).

But what if that INSERT - SELECT - subSELECT is part of a larger BEGIN - END block or within CREATE PROCEDURE?

My 2 cents, having multiple keys to select "current" statement with different scope would be a confusing feature, who would remember all these keys anyway? Maybe it's better to do it gradually, start with the minimal selection using the existing hot key and then have something else to expand the scope of selection by 1 level. Repeated use of the expansion key will select parent blocks/batches until the entire script in the editor is selected. What do you think about that?

Actually, repeated use of Select Current Statement hot key can also serve as the expansion key.

A much better implementation that would be, yes.

Submitted. Thank you.

The incremental selection of current statement is awesome, thank you very much.

You are welcome. That one was actually introduced in 7.1 release about 10 months ago.

Funny I didn't notice it. I use this frequently.