An alternative is to use wrapper libraries that set sane defaults, e.g. https://rogerbinns.github.io/apsw/bestpractice.html

But I suppose it would be nice to have a standard way to refer to those defaults, in a cross-runtime way.