[Feature] Support force keep delete when perform compact

[Stefanietry]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

For chain table, due to out-of-order issues, subsequent deleted data will fall into earlier partitions, resulting in data loss after compaction.

Solution

No response

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!