(pipes-targets): Add Lambda Function target for EventBridge pipes

[WtfJoke]

Describe the feature

Add a implementation for the Lambda Function target for EventBridge pipes in the pipes-targets module.

Use Case

For feature completeness of the L2 pipes module this source is required.

Proposed Solution

No response

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.136.0

Environment details (OS name and version, etc.)

windows 11

[ashishdhingra]

Per Amazon EventBridge Pipes targets, Lambda function (SYNC or ASYNC) is one of the supported target.

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.

[aws-cdk-automation]

Comments on closed issues and PRs are hard for our team to see. If you need help, please open a new issue that references this one.