doh. after all this, 'GROUP BY' isn't supported by DBD::CSV

Sorry, you're mistaken, it is supported. See my reply elsewhere in this thread. The place to look for the SQL syntax supported by DBD::CSV is in SQL::Statement::Syntax. GROUP BY has been supported for the past several releases, but I'd recommend getting the latest release (of SQL::Statement) in any case.