Selecting the SQL Results option only generates the list of values. We need a FIELD that allows the ability to enter SQL statements in the field itself. Take a look at the Use Case and Business Need section of this idea.

"creation of report is dependant on template size and user is restricted in extracting all the columns of the table with a large volume" This is our biggest issue with using the BI Publisher reports.

Yes, please do NOT deprecate this feature. We *absolutely* need it.