use Modern::Perl qw /2014/;
use DBI;
use Data::Dump qw /dump/;

my $dbh = DBI->connect("dbi:CSV:f_dir=.");
$dbh->{csv_allow_whitespace} = 1;

my $sql =
'SELECT names.firstname, names.name, names.ID, scores.ID, scores.score FROM names FULL OUTER JOIN scores ON names.ID = scores.ID';

my $sth = $dbh->prepare($sql);
$sth->execute();
while ( my $row = $sth->fetchrow_hashref ) {
    say dump($row);
}
$sth->finish();