Scan joined query to embedded struct

[omi-donlimit]

Hi, how does one solve this kind of problem (example):

type A struct {
  ID pgtype.Int4 `db:"id"`
}
type B struct {
  ID pgtype.Int4 `db:"id"`
  A
}

SQL:

select A.id, B.id AS b_id from tbl_a as A join tbl_b AS B ON B.id = A.id LIMIT 1

//i also tried
select A.id, row(B.id) as B from tbl_a as A join tbl_b AS B on B.id = A.id LIMIT 1

the sql works if i use it in psql, but in Go/PGX i get QueryRow failed: cannot find field xxxx in returned row

I can use pgx.CollectOneRow(rows, pgx.RowToAddrOfStructByName[B]) to easily bind to B, but how to handle embedded?

[omi-donlimit]

It seems that making the struct:

type B struct {
  ID pgtype.Int4 `db:"id"`
  A  A //this
}

removes the error. I have yet to make it work fully still (A is null)