Add input distribution to delete node

Description

Add an optional field to DeleteNode so that DeleteNode can specify the input data distributions for a DeleteNode.

This PR also include changes which moved the DeleteNode to SPI

To enable specify input data properties for DeleteNode. Default is empty which means no requirement.

Allow to specify input data properties for DeleteNode.

Existing tests.

[ ] Please make sure your submission complies with our development, formatting, commit message, and attribution guidelines.
[ ] PR description addresses the issue accurately and concisely. If the change is non-trivial, a GitHub Issue is referenced.
[ ] Documented new properties (with its default value), SQL syntax, functions, or other functionality.
[ ] If release notes are required, they follow the release notes guidelines.
[ ] Adequate tests were added if applicable.
[ ] CI passed.

Please follow release notes guidelines and fill in the release notes below.

== RELEASE NOTES ==

General Changes
* Add an optional input distribution constraint to DeleteNode :pr:`24104`