It is Go first and foremost, but there are work-in-progress generators for other languages, including Kotlin and (in my opinion, somewhat oddly,) Python.

https://docs.sqlc.dev/en/latest/reference/language-support.h...

It also only supports PostgreSQL as a first class option. It’s still maturing. That said, I’m using PostgreSQL + Go in production with no qualms.