[Feature Request]: Extend YACE config for SQS DLQ dimensions

[michaelpearsonHO]

Before submitting

• I have searched the existing issues and cannot find another that matches this one.

Describe the user need

Due to the limitation on extracting dimensions from localstack aws cloudwatch metrics (localstack/localstack#7092) . We need to add a 2nd static config to YACE to return sqs metrics for a dlq.

Also lacking consistency in the auto-discovery and static YACE config so we'll bring these inline.

Describe the solution you would like

We will have two symetrical set of metrics exposed for the SQS namespace one will be tagged with the dimension_Queuename=standard-queue, the 2nd will be tagged with dimension_Queuename=standard-queue-dlq.

Any other information

No response