My understanding was that "you can't use SQLite in production" was always just a shorthand for "SQLite doesn't support concurrent writes". Obviously still works well in a lot of production application contexts.
The default compilation for SQLite is backwards compatible to all prior versions. With compilation flags, SQLite is a bit more robust. Like a lot of other technologies, we've brought forward our past understanding that obscures current capabilities.
