# Map the data into cols parameter.
my @rows = map { cols=>$_ } @{$datafromquery};
# Later
$template->param(rows=>\@rows);

<!-- the template -->
<tmpl_loop name="rows">
 <tr>
  <tmpl_loop name="cols">
   <td><tmpl_var name="value"></td>
  </tmpl_loop>
 </tr>
</tmpl_loop>