destructive_query
Run a destructive SQL statement only when necessary. It takes a database snapshot first and logs the reason.
Instructions
Run one destructive statement. A snapshot of the database file is written first (the newest few are kept next to the database), then the statement runs. Requires a short reason, which lands in the audit log. Never use this when write_query would do.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | One DELETE, DROP TABLE/VIEW/INDEX, ALTER TABLE, CREATE/DROP TRIGGER or unfiltered UPDATE statement. | |
| reason | Yes | Why this is needed; recorded in the audit log. |