delete
Delete SQLite records by filter or primary key list, or drop schema objects like tables, indexes, triggers, and views with confirmation keys.
Instructions
Delete records or drop a DDL object (https://github.com/ostermeyer/jmd-spec).
Delete (#- Label): filter-based delete (≥1 field required).
#- Order
id: 42Bulk delete (#- Label[]): primary-key list (or objects for composite keys).
#- Order[]
- 42
- 43Schema (#! Label): drop a DDL object. Each kind needs its own confirm-key:
Tables / views (legacy): confirm: drop-table
#! OrderIndexes: confirm: drop-index
#! Index
name: idx_order_statusTriggers: confirm: drop-trigger
#! Trigger
name: trg_log_ordersViews (preferred over the legacy drop-table path): confirm: drop-view
#! View
name: PendingOrdersFrontmatter policy: strict refusal — unknown keys cause an error. Accepted keys: confirm, debug. Debug: 'debug: sql, timing, table'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| document | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |