Take into account the `json:"xxx"` tags associated to a field when aliasing in subqueries

[supercairos]

Describe the bug
See expected behavior

Environment (please complete the following information):

• OS: linux/macosx
• Database: postgres
• Database driver: pg
• Jet version: 2.6.1

Code snippet

type User struct {
	ID uuid.UUID `json:"id" sql:"primary_key" alias:"users.id"`

	FirstName          string `json:"first_name" alias:"users.first_name"`
	LastName           string `json:"last_name" alias:"users.last_name"`
	Sex                string `json:"sex" alias:"users.sex"`
	IsDirectDescendant bool   `json:"is_direct_descendant" alias:"users.is_direct_descendant"`

	BirthDate *time.Time `json:"birth_date" alias:"users.birth_date"`
	DeathDate *time.Time `json:"death_date" alias:"users.death_date"`

	CreatedAt time.Time  `json:"created_at" alias:"users.created_at"`
	UpdatedAt *time.Time `json:"updated_at" alias:"users.updated_at"`
}

SELECT(
		UserAddresses.AllColumns
		SELECT_JSON_AGG(Users.AllColumns).
			FROM(
				Users.
					INNER_JOIN(InternalUserAddresses, Users.ID.EQ(InternalUserAddresses.UserID)),
			).
			WHERE(InternalUserAddresses.ID.EQ(UserAddresses.ID)).
			AS("users"),
	).
		FROM(UserAddresses)

Expected behavior
This query doesn't manage to map the users of an address because every field in the sub-query is aliased in camelCase but in my models it has tags were the json tags are in snake-case.
The only workaround is to alias all column manually.

It works great (as a SQL perspective) if I use a simple SELECT but doesn't if I use SELECT_JSON_AGG

[go-jet]

It works great (as a SQL perspective) if I use a simple SELECT but doesn't if I use SELECT_JSON_AGG

Assuming, you meant SELECT_JSON_ARR, yeah all SELECT_JSON projections by default are named in camelCase format.
You can override this behavior by manually aliasing each column:

stmt := SELECT(
	UserAddresses.AllColumns,

	SELECT_JSON_ARR(
		Users.FirstName.AS("first_name"),
		Users.LastName.AS("last_name"),
		// etc ....
	).FROM(
		Users.
		    INNER_JOIN(InternalUserAddresses, Users.ID.EQ(InternalUserAddresses.UserID)),
	).
	WHERE(InternalUserAddresses.ID.EQ(UserAddresses.ID)).
	AS("users"),

).FROM(UserAddresses)

[supercairos]

Thanks for the prompt response !
That's what I'm doing but would be awesome if it would be infèred automatically!
In the exemple, I have a small number of table, but in real life I have 26 columns so It's a pain to map them all :)

I'm closing for now, as I tought it was a bug but seams like a future feature :)