Trying it gave me a syntax error on the ".".
If not, is there another way of bulk loading data into a sqlite database with similar performance? .import (from the command line) does in under a minute what inserts (wrapped in a transaction) do in over 20 minutes.
I tried using .import after reading Faster bulk inserts in sqlite3?. I've tried all the other suggestions there except for virtual tables.
Thanks!