> anything that depends on Go's Postgres client requires libpq which requires libc

Try https://github.com/lib/pq

I've also seen https://github.com/jackc/pgx used in many projects

> For users that require new features or reliable resolution of reported bugs, we recommend using pgx which is under active development.