(rds): add support for database insights

[sakurai-ryo]

Describe the feature

AWS announces Amazon CloudWatch Database Insights.
https://aws.amazon.com/about-aws/whats-new/2024/12/amazon-cloudwatch-database-insights
https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/Database-Insights.html

Use Case

Database Insights can be easily configured from L2 constructs, allowing users to monitor their Database better.

Proposed Solution

Add DatabaseInsightsMode to Props.

Other Information

No response

Acknowledgements

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

CDK version used

2.173.3 (build 00db01f)

Environment details (OS name and version, etc.)

MacOS

[sakurai-ryo]

Waiting for L1 construct update.

[pahud]

Thank you for the feature request!! Yes, let's wait until L1 is available.

[badmintoncryer]

@sakurai-ryo databaseInsightsMode property has added to the both DB cluster and instance.

#32685