IntelliLang

IntilliLang is a very cool plugin for Idea that (among other things) allows stringified code to be parsed as any other code. This means those regular expressions and html fragments you store as a Java String can be parsed, checked and auto-completed as a first-class citizen.

Jetbrains shows some very cool examples including regular expressions, javascript and el. It still has some rough edges, but once its cleaned up a bit, it could be a great tool for HQL queries and embedded SQL.