There's pgtyped, which I believe does almost the same as sqlc

https://github.com/adelsz/pgtyped