This does seem to come up a few times a year.
Would it be worth adding a mini-tutorial or video to the SQLite shards readme?
I am thinking it could cover how to compile SQLite and link it.
I posted this last time I saw it come up: How to statically link SQLite extension? - #7 by chillfox