aws-rds: Add support for engineLifecycleSupport configuration in L2/L3 constructs for RDS Instances

[mMeijden]

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

[pahud]

Hi @mMeijden,

Thank you for reporting this feature request! The engineLifecycleSupport configuration is indeed available in CloudFormation for RDS instances and should be exposed in our L2/L3 constructs.

This would be a great addition to complement the existing support for RDS clusters that was added in #33859. The implementation would involve:

1. Adding the engineLifecycleSupport property to DatabaseInstanceNewProps
2. Mapping the property in the L2/L3 construct to the underlying CfnDBInstance
3. Adding appropriate documentation and examples

Would you be interested in contributing this change? We'd be happy to guide you through the process. The implementation would be relatively straightforward since we already have a similar pattern from the cluster implementation.

Let us know if you need any clarification or assistance!