Function parseValueExpr

pkg/transform/set.go:36–45

parseValueExpr parses a SQL value expression string using the "SELECT * FROM _t WHERE _col = " trick, returning the right-hand side of the equality. This handles literals, function calls, identifiers, etc.

(valueSQL string)

// "SELECT * FROM _t WHERE _col = <valueSQL>" trick, returning the right-hand
// side of the equality. This handles literals, function calls, identifiers, etc.
func parseValueExpr(valueSQL string) (ast.Expression, error) {
	expr, err := parseCondition(fmt.Sprintf("_col = %s", valueSQL))
	if err != nil {
		return nil, fmt.Errorf("parse value %q: %w", valueSQL, err)
	}
	if bin, ok := expr.(*ast.BinaryExpression); ok {
		return bin.Right, nil
	}
	return expr, nil
}

// AddSetClause returns a Rule that appends a new assignment to the SET clause
// of an UPDATE statement. If a column with the same name already exists (case-