Function normalizeSelectExpr

schema/normalize.go:1178–1205

normalizeSelectExpr normalizes a single SELECT expression for views

(expr parser.SelectExpr, mode GeneratorMode)

// normalizeSelectExpr normalizes a single SELECT expression for views
func normalizeSelectExpr(expr parser.SelectExpr, mode GeneratorMode) parser.SelectExpr {
	switch e := expr.(type) {
	case *parser.AliasedExpr:
		as := e.As
		// For PostgreSQL, strip automatic aliases like ?column?
		if mode == GeneratorModePostgres && as.Name == "?column?" {
			as = parser.NewIdent("", false)
		}
		// For MySQL, strip redundant aliases where the alias matches the column name
		// MySQL adds "column_name as column_name" which is redundant
		if mode == GeneratorModeMysql && !as.IsEmpty() {
			if colName, ok := e.Expr.(*parser.ColName); ok {
				if strings.EqualFold(colName.Name.Name, as.Name) {
					// The alias is the same as the column name, strip it
					as = parser.NewIdent("", false)
				}
			}
		}
		return &parser.AliasedExpr{
			Expr: normalizeExpr(e.Expr, mode),
			As:   as,
		}
	case *parser.StarExpr:
		return e
	default:
		return expr
	}
}

// normalizeTableExprs normalizes FROM clause table expressions
func normalizeTableExprs(exprs parser.TableExprs, mode GeneratorMode) parser.TableExprs {