* Not the default in the original c library ... except it is the default in language wrappers like better-sqlite3 for nodejs.

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.