> (Aside: The hard bit may be getting a new enough SQLite, at the time of writing Homebrew on macOS has it, else you likely need to use an unstable source like nixpkgs-unstable.)
Or just download the source and build it! (Gasp!)
Or just download the source and build it! (Gasp!)
What seems to be happening here is that people have learned that package managers are the right way to install software, but they don’t really understand the reasons, or where and how exceptions might apply. IMO your comment does that as well.
It's POSSIBLE to build it from source, and manually re-download the source and C compiler (and any dependencies, though I'm not sure SQLite has any) when I want to update and instruct any collaborators to do the same thing... But I'd still rather automate it all with a package manager.
Especially because I'm probably also handling other dependencies in the project and I value the uniform simplicity of using a package manager for all of them