Yes you could do it manually, but it would be nice if the solution didn't require carefully managing update queries so the journal addition isn't missed and inc

Yes you could do it manually, but it would be nice if the solution didn't require carefully managing update queries so the journal addition isn't missed and increasing write amplification to manually update a journal table when that information probably already exists somewhere in the WAL implementation.