It would be useful to write a snippet that you could paste the contents of the clipboard into. The contents might contain the name of an object (table, view) that needs to be entered based on the context.

Don't expand wildcard occurrences within EXISTS clause.
WHERE EXISTS(SELECT * FROM tab1)
should not expand to
WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)

Further to the idea presented here http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1712871-enhance-press-tab-to-expand

I would like to see a further enhancement

If I have a query such as

select *
from table t1
join table2 t2 on t1.id = t2.id

and I tab-expand the *, then the columns will be prefixed with the alias name, however if I have limited the query to

select t2.*
from table t1
join table2 t2 on t1.id = t2.id

and tab-expand, then SQL Prompt doesn't use the alias, it uses the tablename. I want to see the alias.