Extend SELECT * support outside of select list

Traditionally * is confined to thr select list and there to the top level of expressions.
Spark does, in an undocumented fashion support * in the SELECT list for function argument list.
Here we want to expand upon this capability by adding the WHERE clause (Filter) as well as a couple of more scenarios such as row value constructors and IN operator.