#!/usr/bin/perl
    use strict;
    use warnings;
    use DBI;
    #use Text::CSV;
    use Data::Dumper;

    # Connect to the database, (the directory containing our csv file(s))

    my $dbh = DBI->connect("DBI:CSV:f_dir=.;csv_eol=\n;");

    # Associate our csv file with the table name 'results'

    $dbh->{'csv_tables'}->{'results'} = { 'file' => 'test.csv'};

    my $sth = $dbh->prepare("SELECT * FROM results WHERE 1=0");
    $sth->execute;
    my @cols = @{$sth->{NAME}};
    my $avgSQL =
      'SELECT '
      . join(', ', map { "avg($_) as $_" } @cols )
      . ' FROM results';
    my $avgsHashRef = $dbh->selectrow_hashref($avgSQL);

    print Dumper $avgsHashRef;