Function renderQuotedIdent

pkg/sql/parser/pivot.go:33–47

renderQuotedIdent reproduces the original delimiters of a quoted identifier token so the parsed value round-trips through the formatter. The tokenizer strips delimiters but records the style in Token.Quote (or, for word tokens, Word.QuoteStyle). Embedded delimiters are escaped per dialect: SQL Serve

(tok models.Token)

// tokens, Word.QuoteStyle). Embedded delimiters are escaped per dialect:
// SQL Server doubles `]`, ANSI doubles `"`, MySQL doubles “ ` “.
func renderQuotedIdent(tok models.Token) string {
	q := tok.Quote
	if q == 0 && tok.Word != nil {
		q = tok.Word.QuoteStyle
	}
	switch q {
	case '[':
		return "[" + strings.ReplaceAll(tok.Value, "]", "]]") + "]"
	case '"':
		return "\"" + strings.ReplaceAll(tok.Value, "\"", "\"\"") + "\""
	case '`':
		return "`" + strings.ReplaceAll(tok.Value, "`", "``") + "`"
	}
	return tok.Value
}

// parsePivotAlias consumes an optional alias (with or without AS) following a
// PIVOT/UNPIVOT clause. Extracted to avoid four copies of the same logic in