More easily run SQL queries from annotation #4
Description
This likely involves some level of IDE integration, starting with NetBeans, which has very good SQL capabilities built-in. It should be easier to get the SQL annotation text somewhere it can be executed against a database that's already configured in the IDE so that it can be tested in an ad-hoc manner. As it stands, the query is in double quotes and might be broken up with quotes and '+' due to the lack of multi-line strings in Java. Also, the variable interpolation works well for NORM workflows, but it is not something that SQL editors generally understand. It might be good to provide a way for the variables to be filled in with user supplies values so that the query can be executed or modified right away.