make it be a sql template

[fxk2006]

hi,I want make it be a best sql template like this: step1: define a sql template text select * from table where name=#name @if age>0 { and age=#age or name=#name @}

step2: when I give one param "name" with value "John",after call your quilktemplate,return a preparedstatment string sql, and a paramslist select * from table where name=? , [ John]

when I give two params "name=John" and "age=12",it should be like this:

select * from table where name=? and age=? or name=?, [John, 12, John]

I think it should be very usefull. thanks

[andys]

@fxk2006 Have you tried sqlc ? It does this kind of thing but with many more useful features