Foo::Bar->set_sql(withlimit => q{
   select * from table
   where field = ?
   limit ?
});

##</code><code>##

select * from table
where field = '20'
limit '10'