Describe the feature

EngineLifecycleSupport can be enabled on RDS Instances via CloudFormation.
This has already been implemented in CDK for clusters (see #33859 ), but this should be made available for DBInstance constructs as well.
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbinstance.html#cfn-rds-dbinstance-enginelifecyclesupport

Use Case

We have use cases where we explicitly disable/enable the engine lifecycle support.
https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_rds.CfnDBInstance.html#enginelifecyclesupport

Proposed Solution

same functionality as #33859

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

AWS CDK Library version (aws-cdk-lib)

2.196.0

AWS CDK CLI version

2.1016.0 (build 66e0b2d)

Environment details (OS name and version, etc.)

any version