It'd be nice if there was a way to [manually checkpoint the WAL file](https://www.sqlite.org/wal.html#:~:text=Application%2DInitiated%20Checkpoints) if you need everything in one file at a certain moment.