propose_change
Preview an INSERT, UPDATE, or DELETE in a rollback transaction to see its real impact without changing data. Get a single-use change_id to confirm the write later.
Instructions
Preview a write without committing it, and get a change_id back.
The statement is validated, executed inside a transaction to compute a real preview, then rolled back. Nothing is written. Show the returned preview to the human and call confirm_change with the change_id to commit it. The id is single use and expires.
Accepts one INSERT, UPDATE or DELETE against an existing table. UPDATE and DELETE must have a WHERE clause.
Args: sql: A single INSERT, UPDATE or DELETE statement.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |