in reply to Specialty database API.
You use a hash, see String::Interpolate/ String::Interpolate::RE , String::Defer, Interpolation, Template,Text::Xslate...
See Querylet
See bobby-tables.com: A guide to preventing SQL injection in Perl