I might have an SQL string split over multiple lines in my code
String sql = "SELECT column_name(s)" +
"FROM table1" +
"LEFT JOIN table2" +
This is fine to make my code a bit more readable, however, it makes it a pain to copy and test the SQL outside of IDEA as I have to strip out the the quotes and plus marks after I paste it.
I can get the full string by running in debug mode and copying the value but that is just as painful.
I eventually found this tiny plugin Java2SQL:
Thumbs up to Andrey, this seems like something that should be included in IDEA by default.