feat(events-targets): Add DLQ support for SQS target

[draftbk]

This is an available feature through the AWS Console already. And is supported in many other target but not SQS: #11612.

Use Case

Use monocdk/aws-events-targets to create DLQ for events-targets as SQS

Proposed Solution

import * as sqs from "@aws-cdk/aws-sqs";
import * as events from "@aws-cdk/aws-events";
import * as targets from "@aws-cdk/aws-events-targets";

const targetSQS = new sqs.Queue(this, 'targetSQS', {
  queueName: 'targetSQS',
});

const rule = new events.Rule(this, 'rule', {
  eventPattern: {
    source: ["aws.ec2"],
  },
});

const myDeadLetterQueue = new sqs.Queue(this, 'myDeadLetterQueue');

rule.addTarget(new targets.SqsQueue(targetSQS, {
  deadLetterQueue: myDeadLetterQueue
}));

[rix0rrr]

This could easily be copy/pasted from other rule targets that do support DLQs.

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