Alright, I verified it's fine to compile-in WAL. The reason it does not work out-of-the-box now is that WAL is only enabled if libsql detects that it's supported, which is currently done via the following heuristics:

1. if we're in exclusive mode, WAL is supported, because we don't need shared memory
2. otherwise, WAL is supported iff VFS supports shared memory, for locking purposes

This heuristics will not be sufficient for us once #53 comes in, because it would be up to the WAL implementation whether it needs locks or not. So, as a workaround for playing with the fiddle app, it's enough to simply turn on exclusive mode in order to enable WAL:

.open file:name?vfs=opfs
PRAGMA main.locking_mode=exclusive;
PRAGMA journal_mode=wal; -- it works!
CREATE TABLE IF NOT EXISTS t1(id);
INSERT INTO t1(id) VALUES (42);
INSERT INTO t1(id) VALUES (43);
SELECT * FROM t1;