Question about --prefix

[dankobg]

Maybe i am misunderstanding how this works but how to have 3 nested structs for, genre, album, artist?
1st query works normally but it's simple and flat, 2nd does not work with prefix.

--First
SELECT
  t.name AS track_name,
  t.milliseconds AS track_milliseconds,
  t.composer AS track_composer,
  g.genre_id AS genre_id,
  g.name AS genre,
  ar.artist_id AS artist_id,
  ar.name AS artist,
  al.album_id AS album_id,
  al.title AS album_title
FROM
  track t
  LEFT JOIN genre g ON t.genre_id = g.genre_id
  LEFT JOIN album al ON t.album_id = al.album_id
  LEFT JOIN artist ar ON al.artist_id = ar.artist_id
ORDER BY
  ar.name,
  genre,
  track_name
LIMIT 100;

--Second
SELECT  
  track.*,
  --prefix:genre.
  genre.*,
  --prefix:album.
  album.*,
  --prefix:artist.
  artist.*
FROM
  track
  LEFT JOIN genre ON track.genre_id = genre.genre_id
  LEFT JOIN album ON track.album_id = album.album_id
  LEFT JOIN artist ON album.artist_id = artist.artist_id
ORDER BY
  track.name
LIMIT 100;

This is what second generates:

SELECT  
  "track"."track_id", "track"."name", "track"."album_id", "track"."media_type_id", "track"."genre_id", "track"."composer", "track"."milliseconds", "track"."bytes", "track"."unit_price",
    "genre"."genre_id", "genre"."name",
    "album"."album_id", "album"."title", "album"."artist_id",
    "artist"."artist_id", "artist"."name"
FROM
  track
  LEFT JOIN genre ON track.genre_id = genre.genre_id
  LEFT JOIN album ON track.album_id = album.album_id
  LEFT JOIN artist ON album.artist_id = artist.artist_id
ORDER BY
  artist.name,
  genre.name,
  track.name
LIMIT 100;

type SecondRow struct {
	TrackID      int32            `db:"track_id"`
	Name         string           `db:"name"`
	AlbumID      sql.Null[int32]  `db:"album_id"`
	MediaTypeID  int32            `db:"media_type_id"`
	GenreID      sql.Null[int32]  `db:"genre_id"`
	Composer     sql.Null[string] `db:"composer"`
	Milliseconds int32            `db:"milliseconds"`
	Bytes        sql.Null[int32]  `db:"bytes"`
	UnitPrice    decimal.Decimal  `db:"unit_price"`
	GenreID      sql.Null[int32]  `db:"genre_id"`
	Name         sql.Null[string] `db:"name"`
	AlbumID      sql.Null[int32]  `db:"album_id"`
	Title        sql.Null[string] `db:"title"`
	ArtistID     sql.Null[int32]  `db:"artist_id"`
	ArtistID     sql.Null[int32]  `db:"artist_id"`
	Name         sql.Null[string] `db:"name"`
}

Basically i get duplicate declarations which is invalid ofc.

[stephenafamo]

--prefix is not yet released.

You will have to pull the latest commit to be able to use it.

[dankobg]

Oh, i see . I read the docs so i assumed it was available.
thanks!