my $complete_match = $sth->fetchall_arrayref({});
$template->param(someloop=>$complete_match);

HTML:
<tmpl_loop someloop>
   <tmpl_var column1><tmpl_var column 2> etc...
</tmpl_loop>