I suggest to add something like NamedParamObject to standard object set, which will convert e.g. string "paramName" to ":paramName", as it is widely used in prepared statements.
Some tools and extensions support it: SQLJ (in SQLJ this syntax is used for host expressions, but this only influences possible class name, not the sense), Spring and other. Why not to use sqlbuilder with them more easily.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
what type of prepared statements? jdbc doesn't support that syntax.
Some tools and extensions support it: SQLJ (in SQLJ this syntax is used for host expressions, but this only influences possible class name, not the sense), Spring and other. Why not to use sqlbuilder with them more easily.
not sure i see the benefit of a whole new class for this, maybe just a util method:
public static SqlObject namedParamObject(String paramName) {
return new CustomSql(":" + paramName);
}
fixed in trunk, will be in the 2.1.1 release.