Interesting read.
For what it's worth, coming from an era where it was trivial to cross compile, I can't help but think that the real issue here is:
> sqlite is of course a C project – so to facilitate cross-platform building, (...) zig cc is used to compile sqlite when targeting Linux