[Feature Request]: CREATE/DELETE PITR Internal API call and internal SQL executor support

[cpegeric]

Is there an existing issue for the same feature request?

• [x] I have checked the existing issues.

Is your feature request related to a problem?

CREATE PITR or DELETE IF EXISTS PITR SQL cannot be run from internal sql executor.  A new API call and internal SQL executor support should be provided.

e.g.

drop pitr if exists `cdctest`.`__mo_index_pitr_cdctest_src`;

CREATE PITR `__mo_index_pitr_cdctest_src` FOR TABLE `cdctest` `src` range 2 'h';

Describe the feature you'd like

Provide the API call and support internal SQL executor that provide the same function to create/delete pitr.

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

Additional information

No response