Jing-SQL is a small set of utilities that seperate out SQL from java code. It is currently based on Jakarta Velocity and Apache Avalon , but it should work within PicoContainer fairly well, or even just in non-component based architectures. Someday I might add more scripting support or Jelly support too. :)
Note : Jing-SQL was designed as a "proof-of-concept" and an experimentation into Velocity programming. While the idea of seperating SQL from your Java code is appealing, there are many performance issues to consider. Tightly written JDBC code or use of a well designed O/R tool like Hibernate will generally have better performance than JingSQL.