Implementing Soft Delete Logic

@Entity
@SQLDelete(sql = "UPDATE orders SET deleted_at = now() WHERE id = ?")
@SQLRestriction("deleted_at IS NULL")
public class Order { ... }

@PostMapping("/orders/{id}/restore")
@PreAuthorize("hasRole('ADMIN')")
public Order restore(@PathVariable UUID id) {
    int updated = jdbc.update(
        "UPDATE orders SET deleted_at = NULL WHERE id = ? AND deleted_at IS NOT NULL", id);
    if (updated == 0) throw new NotFoundException("order", id);
    return orderRepo.findById(id).orElseThrow();
}

@Scheduled(cron = "0 0 3 * * *")
public void purgeOldDeletes() {
    jdbc.update("""
        DELETE FROM orders
        WHERE deleted_at IS NOT NULL
          AND deleted_at < now() - interval '30 days'""");
}

UPDATE orders SET deleted_at = now(), deleted_by = :actor
WHERE id = ANY(:ids) AND deleted_at IS NULL;