Optional execution in conjunction with select on {var}

[shimonchayim]

Currently if we don't want select (or delete) on a proper table to not get executed if a param is empty then we do
select * from A where a = "{^var1}"

If A is variable and var1 is empty then the statement doesn't get executed as expected but if var1 is not empty then the filter goes into effect and unlike select on table, where clause does have ramifications on the result.

We may need to think about a way where select on a {var} can be made optional without tying it to the where clause.

[jasxie]

let's discuss