I wonder why pgtyped [1] was skipped
How does this compare with pgTyped[1]?
There's pgtyped, which I believe does almost the same as sqlc
For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?
You might also want to consider pgTyped (https://github.com/adelsz/pgtyped). It's supposed to make SQL and TS work together. I haven't gotten around to using it yet but I hear good things.
Update: This list can be brought down to 3, if Java is substituted with TypeScript(/WASM-target for the future?), with a type-safe SQL codegen library such as: https://github.com/adelsz/pgtyped
Update update: Or reluctantly with Python instead, with a similar library such as PugSQL.
PgTyped is another high quality alternative: https://github.com/adelsz/pgtyped.
We're using a very similar lib for typescript: https://github.com/adelsz/pgtyped
Would love to hear if any others of comparable or better quality exist for js/ts