Method FormatSQL

parser/format.go:1776–1816

(formatter *Formatter)

}

func (j *JSONOptions) FormatSQL(formatter *Formatter) {
	formatter.WriteByte('(')
	// Ensure stable, readable ordering:
	// 1) numeric options (max_dynamic_*), 2) type-hint items, 3) skip options (SKIP, SKIP REGEXP)
	// Preserve original relative order within each group.
	numericOptionItems := make([]*JSONOption, 0, len(j.Items))
	columnItems := make([]*JSONOption, 0, len(j.Items))
	skipOptionItems := make([]*JSONOption, 0, len(j.Items))
	for _, item := range j.Items {
		if item.MaxDynamicPaths != nil || item.MaxDynamicTypes != nil {
			numericOptionItems = append(numericOptionItems, item)
			continue
		}
		if item.Column != nil {
			columnItems = append(columnItems, item)
			continue
		}
		if item.SkipPath != nil || item.SkipRegex != nil {
			skipOptionItems = append(skipOptionItems, item)
			continue
		}
		// Fallback: treat as numeric option to avoid dropping unknown future fields.
		numericOptionItems = append(numericOptionItems, item)
	}

	wroteItem := false
	writeItems := func(items []*JSONOption) {
		for _, item := range items {
			if wroteItem {
				formatter.WriteString(", ")
			}
			item.FormatSQL(formatter)
			wroteItem = true
		}
	}

	writeItems(numericOptionItems)
	writeItems(columnItems)
	writeItems(skipOptionItems)
	formatter.WriteByte(')')
}

func (j *JSONType) FormatSQL(formatter *Formatter) {
	formatter.WriteExpr(j.Name)