We use a lot of dynamic SQL. I'd like to be able to format dynamic SQL that is in a string, eg. and NVARCHAR. e.g.

Input: DECLARE @sql NVARCHAR = '

SELECT foo from bar where foobar = ''foobarred''
'

I'd like to be able to highlight the text inside the NVARCHAR for formatting. SQL Prompt would need to handle doubled quotation marks as in my example above.