in reply to DBD::SQLite dilemma

Coming in late, but another vote for option 3. IIRC, the DBI has for as long as I've been using it (6 or 7 years) said that the number of rows is not returned from a SELECT execute. Anything that relied on this feature was programming by coincidence.

M-x auto-bs-mode