Method SQL

pkg/sql/ast/sql.go:632–679

SQL returns the full SQL string for this INSERT statement, including the optional WITH clause, column list, VALUES rows or SELECT subquery, ON CONFLICT clause, and RETURNING clause.

()

// optional WITH clause, column list, VALUES rows or SELECT subquery, ON CONFLICT
// clause, and RETURNING clause.
func (i *InsertStatement) SQL() string {
	if i == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)

	if i.With != nil {
		sb.WriteString(i.With.SQL())
		sb.WriteString(" ")
	}

	sb.WriteString("INSERT INTO ")
	sb.WriteString(i.TableName)

	if len(i.Columns) > 0 {
		sb.WriteString(" (")
		sb.WriteString(exprListSQL(i.Columns))
		sb.WriteString(")")
	}

	if i.Query != nil {
		sb.WriteString(" ")
		sb.WriteString(stmtSQL(i.Query))
	} else if len(i.Values) > 0 {
		sb.WriteString(" VALUES ")
		rows := make([]string, len(i.Values))
		for idx, row := range i.Values {
			vals := make([]string, len(row))
			for j, v := range row {
				vals[j] = exprSQL(v)
			}
			rows[idx] = "(" + strings.Join(vals, ", ") + ")"
		}
		sb.WriteString(strings.Join(rows, ", "))
	}

	if i.OnConflict != nil {
		sb.WriteString(onConflictSQL(i.OnConflict))
	}

	if len(i.Returning) > 0 {
		sb.WriteString(" RETURNING ")
		sb.WriteString(exprListSQL(i.Returning))
	}

	return sb.String()
}

// SQL returns the full SQL string for this UPDATE statement, including the
// optional WITH clause, SET assignments, FROM clause, WHERE condition, and