[IshKebab]

> What does that really buy you

It removes a footgun for new users. That's not an insignificant benefit.

Probably not worth the backwards compatibility cost, but it definitely is an issue.

[ncruces]

My builds of SQLite do enable foreign keys by default.

This is easy to do for any project using the amalgamation.