Per this post [0] by Andrew Kelley, Zig's lead developer, projects with "large dependency trees" are better off using other tools than rely on Zig's cross-compile magic.
DuckDB needs Python3 to build as well, so not sure how easy it might be to get it cross-compile with Zig CC.
Gotcha. Targeting musl instead of glibc with Zig CC should get you a statically-linked binary, though, unsure if duckdb and its deps play nice with musl.
Personally, a duckdb golang binary interests me. But: I haven't yet mustered enough patience to sit through a time-consuming duckdb build.
DuckDB needs Python3 to build as well, so not sure how easy it might be to get it cross-compile with Zig CC.
[0] https://archive.is/7SuAf