I've now fixed this for the upcoming 0.42, which also accepts arra-refs with magic.

Meanwhile, I learned that arra-refs with magig have some other magical behaviour too, so that:

$csv->print (*STDOUT, \@{$sth->{NAME_lc}});
[download]

also works. Personally I find this a bit counter-intuitive. The next release will support

$csv->print (*STDOUT, $sth->{NAME_lc});
[download]

If you can't wait for the official release, get it here.