Skip to content

Release Notes — v1.12

Release date: April 2026

This release adds soft_delete_active_value for explicit active-row marking in merge soft-delete patterns.

soft_delete_active_value

When using on_no_match_source: soft_delete, weevr marks unmatched target rows with the configured soft_delete_value. Previously, matched and newly inserted rows received null in the soft delete column — which worked but left the column inconsistent (explicit true for deleted, null for active).

soft_delete_active_value lets you set an explicit value for active rows:

write:
  mode: merge
  match_keys: [customer_id]
  on_no_match_source: soft_delete
  soft_delete_column: is_deleted
  soft_delete_value: true
  soft_delete_active_value: false

With this config, deleted rows get is_deleted = true and active rows get is_deleted = false — no nulls in the column.

Key details:

  • Optional — defaults to null (preserving existing behavior)
  • Type — bool | null, matching soft_delete_value
  • Applied to — matched updates and new inserts during merge operations with soft delete enabled