On: How We Went All In on sqlc/pgx for Postgres and Go

[erdemozg]

Can you provide some resources about the lack of support for joins in sqlc? Because I wasn't able to find in official documentation and actually there's a discussion on github containing queries with join statements: https://github.com/kyleconroy/sqlc/issues/213

[Foobar8568 → erdemozg]

Yes, I was about to reply to myself with a link to this issue as I couldn't see anything in official docs unless looking at the github issues.

https://github.com/kyleconroy/sqlc/issues/1157

[erdemozg → Foobar8568]

But it seems like this discussion is about the lack of support for null values in enum types in joins (not joins in general). Am I missing something?

[Foobar8568 → erdemozg]

I got it wrong because of lack of documentations and examples in the official documentation. So one would be only aware of the feature if they read the issue tracker which is dumb, joining two entities (or more) is like the first thing you want to do with a database.