error when running on SCRATCH image ( partially solved )

Hello everyone, I tried to build a module using your go-sqlite3 package and run the resulting binary inside a SCRATCH image.

The build is done inside a github ubuntu runner, with basic go-install action + apt-install build-essential.

Unfortunately when running the container, I got a runtime error which was exec /go/src/{my_binary_name}: no such file or directory

After various search found out it was due to dynamic linking, managed to make everything works by adding those flags to the goreleaser

    ldflags: -s -w -linkmode external -extldflags "-static"
    flags: --tags netgo

I am not good enough to understand what happens under the hood, and why it solved it, but maybe it could be usefull to some people to improve the documentation and this use case.

Ps: can provide more details in order to reproduce it, just let me know.

Regards,
JC

Start by reproducing the Go binary in a SCRATCH container and compare the working Goreleaser ldflags and netgo setting with the failing build. Document the relevant static-linking configuration and the expected container runtime result, using the reporter's reproduction details if provided.