my $ref = $sth->fetchall_hashref('key_field');
for my $key( %$ref ) {
    $ref->{$key}->{some_field} = modify( $ref->{$key}->{some_field} );
}

# pass modified hash to HTML::Template

sub modify {
   my $val = shift;
   # modify val
  return $val;
}