my $sql = <<__END_SQL__;
YOUR STATEMENT HERE
__END_SQL__

$sql .= "LIMIT $start, $chunk_size\n";

my $sth = $dbh->prepare( $sql );
# etc.