Unformat Query
Add a menu Item option to unformat a query. In other words take the query that is highlighted or every query in the script and convert them to be on a single line with only a single space between keywords, words, and operators.
This would be very useful for having to copy SQL into a table or other some object that shouldn't have normal formatting in it.
An option would be to double up all single quotes, so that the query can be placed between single quotes.
6
votes
Joel Isenstadt
shared this idea
-
Traber
commented
Great idea. I hadn't thought of a tool doing that before and it seems like an easy feature for SQL Prompt since it already parses the query.
I've needed that functionality before to be able to insert a long query into JSON.