Method SQL

pkg/sql/ast/sql.go:1169–1199

SQL returns the SQL representation of this Insert node (dml.go type). For the full-featured INSERT use InsertStatement.SQL() instead.

()

// SQL returns the SQL representation of this Insert node (dml.go type).
// For the full-featured INSERT use InsertStatement.SQL() instead.
func (i *Insert) SQL() string {
	if i == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("INSERT INTO ")
	sb.WriteString(tableRefSQL(&i.Table))
	if len(i.Columns) > 0 {
		sb.WriteString(" (")
		sb.WriteString(exprListSQL(i.Columns))
		sb.WriteString(")")
	}
	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 len(i.ReturningClause) > 0 {
		sb.WriteString(" RETURNING ")
		sb.WriteString(exprListSQL(i.ReturningClause))
	}
	return sb.String()
}

// SQL returns the SQL representation of this Update node (dml.go type).
// For the full-featured UPDATE use UpdateStatement.SQL() instead.