These are all fair points though they mostly can be addressed at the application layer. One could, for example, use a wrapper that opens the sqlite library and

These are all fair points though they mostly can be addressed at the application layer. One could, for example, use a wrapper that opens the sqlite library and immediately turns foreign keys on. One does this once per language in your project and never think about it again. Similarly, type constraints can be enforced at the application layer. I agree that it would be nice if some of these things were built in but at least sqlite is reliable when configured and used in particular ways.