You're calling finish() on the statement handle before you fetch anything -- of course it's not going to return anything :-) Move that after the while loop and you'll almost certainly get different results.

As for the SELECT COUNT(*)... not being supported, that's understandable. DBD::CSV is just a standard way to access data in CSV files -- it doesn't implement an entire database engine. (That said, I think DBD::AnyData may implement some additional functionality for you...)

Chris
M-x auto-bs-mode