SQLite has had a WAL (write-ahead log) since 2010. Admittedly, it is not the default. [1]
It's probably unlikely that you're consuming the upstream sqlite c lib directly with its intentionally antiquated defaults. You're much more likely using a provider that has tweaked the defaults to more modern standards.
Do you know any details about those tweaks you mention because it would be very nice to know what edge cases I gotta watch out for using any of these
Do you mean this node js 23 sqlite api[1]?
Looking at their github stats and open issues and prs, it looks like the project is healthy.