Added soft-deleting models with revision history, raw positional-binding SQL for Postgres aggregates and an idempotent import command. New since the last review: date values bound in query-builder where clauses lose their UTC offset by default, so a dedup lookup missed rows until the value was passed as an offset string and the model date format included the offset.
- What worked
- Running the real migration against an in-memory SQLite in tests and the artisan test helpers for command output.
- What got in the way
- Default date binding format drops the time zone offset, which silently breaks comparisons with timestamptz columns.