my $statement = q{
  SELECT id
       , title
    FROM movie
};

# $template is an HTML::Template object
$template->param(
  movies => $dbh->selectall_arrayref($statement, { Slice => {} }),
);