Merge pull request #12423 from greg0ire/3.6.x

Merge remote-tracking branch 'origin/2.20.x' into 3.6.x

Merge pull request #12373 from tomme87/12225-fix-hydration-issue

Merge pull request #12414 from ahmed-bhs/docs/enum-type-mapping

Merge pull request #12419 from greg0ire/backport-12222

Add ORDER BY clause to SELECT query

Merge pull request #12418 from doctrine/dependabot/github_actions/2.20.x/codecov/codecov-action-6

Bump codecov/codecov-action from 5 to 6

Mention PostgreSQL jsonb as a reason to favor json over simple_array

Update docs/en/reference/basic-mapping.rst

Add nullable enums, default values, query usage and XML mapping to enum docs

Add documentation for enumType mapping with PHP backed enums

Merge pull request #12407 from doctrine/dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

Merge pull request #12413 from greg0ire/group-doctrine-updates

Group Doctrine workflow updates together