Method formatSelect

cmd/gosqlx/cmd/sql_formatter.go:118–234

formatSelect formats SELECT statements with proper indentation and alignment

(stmt *ast.SelectStatement)

// formatSelect formats SELECT statements with proper indentation and alignment
func (f *SQLFormatter) formatSelect(stmt *ast.SelectStatement) error {
	// WITH clause
	if stmt.With != nil {
		if err := f.formatWithClause(stmt.With); err != nil {
			return err
		}
		f.writeNewline()
	}

	// SELECT keyword and columns
	f.writeKeyword("SELECT")
	if stmt.Distinct {
		f.builder.WriteString(" ")
		f.writeKeyword("DISTINCT")
	}

	if f.compact {
		f.builder.WriteString(" ")
		f.formatExpressionList(stmt.Columns, ", ")
	} else {
		f.writeNewline()
		f.increaseIndent()
		f.builder.WriteString(f.currentIndent())
		f.formatExpressionList(stmt.Columns, ",\n"+f.currentIndent())
		f.decreaseIndent()
	}

	// FROM clause
	if len(stmt.From) > 0 {
		f.writeNewline()
		f.writeKeyword("FROM")
		f.builder.WriteString(" ")
		f.formatTableReferences(stmt.From)
	}

	// JOINs
	for _, join := range stmt.Joins {
		join := join // G601: Create local copy to avoid memory aliasing
		f.writeNewline()
		if err := f.formatJoin(&join); err != nil {
			return err
		}
	}

	// WHERE clause
	if stmt.Where != nil {
		f.writeNewline()
		f.writeKeyword("WHERE")
		f.builder.WriteString(" ")
		if err := f.formatExpression(stmt.Where); err != nil {
			return err
		}
	}

	// GROUP BY clause
	if len(stmt.GroupBy) > 0 {
		f.writeNewline()
		f.writeKeyword("GROUP BY")