[sqlite] improve performance of sqlite generation by proper PRAGMA

Also, force WAL checkpoint at the end, otherwise the DB might be incomplete.