Method SQL

pkg/sql/ast/sql.go:336–373

SQL returns the SQL representation of this function call including arguments, optional DISTINCT modifier, ORDER BY clause (for aggregates like STRING_AGG), WITHIN GROUP (for ordered-set aggregates), FILTER (WHERE ...) clause, and OVER (...) window specification.

()

// WITHIN GROUP (for ordered-set aggregates), FILTER (WHERE ...) clause, and
// OVER (...) window specification.
func (f *FunctionCall) SQL() string {
	if f == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString(f.Name)
	sb.WriteString("(")
	if f.Distinct {
		sb.WriteString("DISTINCT ")
	}
	args := make([]string, len(f.Arguments))
	for i, arg := range f.Arguments {
		args[i] = exprSQL(arg)
	}
	sb.WriteString(strings.Join(args, ", "))
	if len(f.OrderBy) > 0 {
		sb.WriteString(" ORDER BY ")
		sb.WriteString(orderBySQL(f.OrderBy))
	}
	sb.WriteString(")")
	if len(f.WithinGroup) > 0 {
		sb.WriteString(" WITHIN GROUP (ORDER BY ")
		sb.WriteString(orderBySQL(f.WithinGroup))
		sb.WriteString(")")
	}
	if f.Filter != nil {
		sb.WriteString(" FILTER (WHERE ")
		sb.WriteString(exprSQL(f.Filter))
		sb.WriteString(")")
	}
	if f.Over != nil {
		sb.WriteString(" OVER (")
		sb.WriteString(windowSpecSQL(f.Over))
		sb.WriteString(")")
	}
	return sb.String()
}

// SQL returns "EXTRACT(field FROM source)" as a SQL string.
func (e *ExtractExpression) SQL() string {