Function renderSelect

pkg/formatter/render.go:197–330

─── statement renderers ─────────────────────────────────────────────────────

(s *ast.SelectStatement, opts ast.FormatOptions)

// ─── statement renderers ─────────────────────────────────────────────────────

func renderSelect(s *ast.SelectStatement, opts ast.FormatOptions) string {
	if s == nil {
		return ""
	}

	// Dialect normalization: work on a shallow copy so the original AST is not mutated.
	stmt := *s
	s = &stmt
	normalizeSelectForDialect(s, opts.Dialect)

	f := newNodeFormatter(opts)
	sb := f.sb

	if s.With != nil {
		sb.WriteString(renderWith(s.With, f))
		sb.WriteString(f.clauseSep())
	}

	sb.WriteString(f.kw("SELECT"))
	sb.WriteString(" ")

	if len(s.DistinctOnColumns) > 0 {
		sb.WriteString(f.kw("DISTINCT ON"))
		sb.WriteString(" (")
		sb.WriteString(exprListSQL(s.DistinctOnColumns))
		sb.WriteString(") ")
	} else if s.Distinct {
		sb.WriteString(f.kw("DISTINCT"))
		sb.WriteString(" ")
	}

	// Render TOP clause (SQL Server). Emitted between SELECT [DISTINCT] and columns.
	if s.Top != nil {
		sb.WriteString(f.kw("TOP"))
		sb.WriteString(" ")
		sb.WriteString(FormatExpression(s.Top.Count, opts))
		if s.Top.IsPercent {
			sb.WriteString(" ")
			sb.WriteString(f.kw("PERCENT"))
		}
		if s.Top.WithTies {
			sb.WriteString(" ")
			sb.WriteString(f.kw("WITH TIES"))
		}
		sb.WriteString(" ")
	}

	sb.WriteString(exprListSQL(s.Columns))

	if len(s.From) > 0 {
		sb.WriteString(f.clauseSep())
		sb.WriteString(f.kw("FROM"))
		sb.WriteString(" ")
		froms := make([]string, len(s.From))
		for i := range s.From {
			froms[i] = tableRefSQL(&s.From[i], f)
		}
		sb.WriteString(strings.Join(froms, ", "))