Handle Duplicate Column names while joining multiple tables automatically

[utkarshpaliwal9]

What do you want to change?

Joining two tables having a similar column name, name (say), produces Golang object fields as Name_1 and Name_2. This not only is confusing but also breaks linters checking for snake_case in the code.

Adding table names before the Golang field name automatically could be a better solution to this.

SELECT * FROM table1 INNER JOIN table2 ON <condition>;

Go fields should automatically create resultant DB Row object as:

type ResultRow struct {
    Table1Name <type>
    Table2Name <type>
}

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Golang

[utkarshpaliwal9]

SELECT query itself can for sure be written using AS but it's cumbersome when there are a lot of columns.

[tardisx]

It would be nice to be able to do something like:

SELECT users.*, addresses.*
FROM users, addresses
WHERE addresses.users_id = users.id;

And have a way to annotate the query so that instead of:

row.Id   // users.id
row.Id_2 // addresses.id

you could get:

row.UsersId
row.AddressesId

I know it's probably better practice to explicity list all columns (and AS them to fix this problem) but I think the wildcard solution with predictable names (that don't change if a new table gets JOIN'd in) is still acceptable.

[kyleconroy]

Fixed via sqlc.embed https://docs.sqlc.dev/en/stable/howto/embedding.html