I suggest another approach:
textql -query "select count(*) from persons.csv"
...because csv files are basically tables. This would also allow you to do joins on multiple files:
textql -query "select p.name, c.name from persons.csv p inner join companies.csv c on p.companyid = c.id"