in reply to DBD::SQLite will connect and CREATE, but not INSERT...sort of

my $sql = sprintf 'INSERT INTO rowdata VALUES( %s )', join(',', @row);
...
This gives me the following error:
INSERT failed: near ")": syntax error(1) at dbdimp.c line 271
That smells to me like your @row is empty, and thus, your SQL statement actually is:
INSERT INTO rowdata VALUES()