Function normalizeViewDefinition

schema/normalize.go:1400–1444

normalizeViewDefinition normalizes a view definition AST for comparison. This function removes database-specific formatting differences that don't affect the logical meaning. If tableLookup is provided, SELECT * expressions are expanded to explicit column names (PostgreSQL expands * when storing vie

(stmt parser.SelectStatement, mode GeneratorMode, tableLookup TableLookupFunc)

// If tableLookup is provided, SELECT * expressions are expanded to explicit column names
// (PostgreSQL expands * when storing view definitions).
func normalizeViewDefinition(stmt parser.SelectStatement, mode GeneratorMode, tableLookup TableLookupFunc) parser.SelectStatement {
	if stmt == nil {
		return nil
	}

	switch s := stmt.(type) {
	case *parser.Select:
		selectExprs := s.SelectExprs
		// Expand SELECT * if we have table lookup capability
		if tableLookup != nil && hasStarExpr(selectExprs) {
			if tableName := extractTableNameFromFrom(s.From); !tableName.IsEmpty() {
				if table := tableLookup(tableName); table != nil {
					selectExprs = expandStarExpr(selectExprs, table)
				}
			}
		}
		return &parser.Select{
			Cache:       s.Cache,
			Comments:    nil, // Remove comments for view comparison - they don't affect semantic meaning
			Distinct:    s.Distinct,
			Hints:       s.Hints,
			SelectExprs: normalizeSelectExprs(selectExprs, mode),
			From:        normalizeTableExprs(s.From, mode),
			Where:       normalizeWhere(s.Where, mode),
			GroupBy:     normalizeGroupBy(s.GroupBy, mode),
			Having:      normalizeWhere(s.Having, mode),
			OrderBy:     normalizeOrderBy(s.OrderBy, mode),
			Limit:       s.Limit,
			Lock:        s.Lock,
			With:        normalizeWith(s.With, mode),
		}
	case *parser.Union:
		return &parser.Union{
			Type:    s.Type,
			Left:    normalizeViewDefinition(s.Left, mode, tableLookup),
			Right:   normalizeViewDefinition(s.Right, mode, tableLookup),
			OrderBy: normalizeOrderBy(s.OrderBy, mode),
			Limit:   s.Limit,
			Lock:    s.Lock,
			With:    normalizeWith(s.With, mode),
		}
	default:
		return stmt
	}
}

// hasStarExpr checks if there's a StarExpr in the SELECT list.
func hasStarExpr(exprs parser.SelectExprs) bool {