This change stops the prevent-destroy permission from applying to records within
projects that are `pending_delete: true`. The purpose of the `prevent` is to
make "archived" projects reliably read-only, but this obviously shouldn't be the
case if someone is deleting a project.

This hasn't been an issue before since we relied on FK constraints to remove the
associated records after a project is deleted. But with the FKs going away in
the database decomposition effort, so too must our cascading destroys.

Changelog: fixed

Fix agent install page paths

See merge request gitlab-org/gitlab!74120

Add issue to troubleshooting sections for API Security

See merge request gitlab-org/gitlab!74130

Update Vulnerability-Check related documentation

See merge request gitlab-org/gitlab!74119

Update go docs to suggest usage of go-cmp

See merge request gitlab-org/gitlab!73323

Docs: Updated runner API deprecation notice

See merge request gitlab-org/gitlab!74145

Remove `toExist` jest matcher

See merge request gitlab-org/gitlab!73874

Merge getIdFromGraphQLId utils

See merge request gitlab-org/gitlab!74038

Added announced date and changed style from quotes
to code

Add clarity regarding SSO enforcement

See merge request gitlab-org/gitlab!74131

Allow to enable query analyzers in production

See merge request gitlab-org/gitlab!74078

Board scope follow up

See merge request gitlab-org/gitlab!74041

Service Accounts for `Project :: Google Cloud`

See merge request gitlab-org/gitlab!73895

Remove dependencies from under the artifacts keyword

See merge request gitlab-org/gitlab!74061

Redirect to continuous onboarding after trial reg

See merge request gitlab-org/gitlab!73594

Fixes autoloading  in development environment for LoadBalancing constant

See merge request gitlab-org/gitlab!74129

Add opensource plan to database

See merge request gitlab-org/gitlab!73925

Do not send parsing errors to Sentry as they are not exceptions

See merge request gitlab-org/gitlab!74085

Save Crystalball mapping for frontend fixtures

See merge request gitlab-org/gitlab!74083

Docs: Remove reference to removed variables

See merge request gitlab-org/gitlab!68424

Query all partitions when loading loose FK records

See merge request gitlab-org/gitlab!74072

Add a query optimisation for fetching group labels

See merge request gitlab-org/gitlab!73501

Fixed files:
- lib/gitlab/database/load_balancing/sidekiq_server_middleware.rb
- lib/gitlab/database/load_balancing/load_balancer.rb

Update Gitaly version

See merge request gitlab-org/gitlab!74122

Fixed yaml file name and regenerated deprecations doc

See merge request gitlab-org/gitlab!74125

Remove upper index size limit for reindexing

See merge request gitlab-org/gitlab!73951

Move EE::AuditEvent specs to correct location

See merge request gitlab-org/gitlab!74108

Doc consistency edits for user/infrastructure

See merge request gitlab-org/gitlab!73784

Fix built-in template import creating duplicate audit logs

See merge request gitlab-org/gitlab!73822

Verify runner s3 authenticationtype deprecation

See merge request gitlab-org/gitlab!73891

Verify Runner disable_strict_host_key_checking deprecation

See merge request gitlab-org/gitlab!73892