[GitHub Request] Enable merge queues for SQL

[Swiddis]

What is the type of request?

Repository Management

Details of the request

We've had an RFC open for a while now to start using merge queues for managing lots of simultaneous feature merges. I'd like to actually implement that change by enabling merge queues for the SQL repository. There's a corresponding SQL update.

(The merge method might need to be changed to Squash for the queue if it's not the default)

Additional information to support your request

As an alternative, we've used auto-merge for a while, but auto-merge depends on branch protections blocking on all CI. It won't let us configure exactly which actions are blocking, it still doesn't do any post-merge protection, and it can't be reliably used for merging sequential PRs or those "looks good, just fix this one thing" cases. This removes a lot of the core reason for using auto-merge to begin with.

When does this request need to be completed?

At your convenience.

Notes

Track the progress of your request here: Engineering Effectiveness Board (view).
Member of @opensearch-project/admin will take a look at the request soon.
Thanks!

[gaiksaya]

@Swiddis Can you confirm what the setting looks like at the repo level? Also can you get some approvals from other maintainers as well for this on your RFC or here?

Thanks!