Optimize DELETE performance for range deletion

[overvenus]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

Range deletion is being translated into multiple single deletion SQL in the drainer. The overhead could be huge, and they slow down the synchronization.

2. What did you expect to see?

For this case, the drainer should be able to understand range deletion or able to optimize multiple single deletion.

3. What did you see instead?

4. Please provide the relate downstream type and version of drainer.
   (run drainer -V in terminal to get drainer's version)