There may be better solutions, but you don't need to scan the SQL, just put it as subquery:
sqlite3_printf "Select Count(*) from (%s)", pSQL
will do the work for you.
Remember what i said about Group by clauses.
Anyway i think a function like sqlite3_row_count(hStmt) would be fantastic.
Marcelo.
