>SQLite is great for storing application state and config options set from within the app, but it is a pretty terrible format for end users to edit.

I think you are conflating the file with the workflow. A proper UI is the solution to making something not "terrible for end users to edit".