Describe the bug

Using the addRotationSingleUser call against an RDS database cluster creates a lambda via the Serverless Application Repository. At present the code for this application points to version 1.1.225 of the application, which uses Python 3.7, which is now EOL.

From checking the AWS console, a newer version is available (1.1.367) which uses Python 3.9, which is still within security support.

Expected Behavior

Rotation lambda uses a supported python runtime.

Current Behavior

Rotation lambda uses an unsupported python runtime.

Reproduction Steps

Deploy a rotation lambda using addRotationSingleUser (we're using Postgres but I'm pretty sure this will affect all RDS platforms)

Possible Solution

Update the version used against the Serverless Application Repository to 1.1.367

Additional Information/Context

No response

CDK CLI Version

2.83.0

Framework Version

No response

Node.js Version

18

OS

Mac OS

Language

Typescript

Language Version

No response

Other information

No response