add new test for WAL journal_mode

I think once this test passes your Query and Exec implementations, we should be OK.

Reason Exec cannot implicitly do Begin/Rollback/Commit is because some PRAGMA's aren't allowed inside a transaction, such as journal_mode.