ColumnExpr with Relation queries

[YeemBoi]

Hi,
I've been looking for functionality similar to ColumnExpr() that will select into the right field when used in a Relation query.
Although it's a different module, go-pg's Issue #1852 describes this exact problem.

This could, perhaps, be addressed be implementing a function similar to *InsertQuery.Value(column string, expr string, args ...interface{}), so that the name of the column could be taken as a separate argument. Then, maybe it could be handled similar to the way #139 addressed this?

See this gist for a clearer example.
Any help would be much appreciated.

[vmihailenco]

Can you try:

func AlsoAnInvalidRelationQuery(q *bun.SelectQuery) *bun.SelectQuery {
	return q.ColumnExpr("? AS author__name", "Ronald")
}

[YeemBoi]

Sorry for your time, the issue was that the Relation() apply func was being used in different joins (with different prefixes / aliases)...

The solution is to pass the prefix / alias (eg "author__") to a parent func

func GetRelationQuery(joinPrefix string) func(*bun.SelectQuery) *bun.SelectQuery {
	return func(q *bun.SelectQuery) *bun.SelectQuery {
		return q.ColumnExpr("? AS ?", "Ronald", bun.Ident(joinPrefix+"name"))
	}
}