## Linked issue

n/a — routine RC release.

## Summary

Prepare **8.0.0-rc.8 → 8.0.0-rc.9**, keeping workspace versions,
internal dependency specifiers, and the shipped `prisma-8` skill version
in lockstep. The curated [release
notes](https://github.com/prisma/orm/blob/release/8.0.0-rc.9/docs/releases/v8.0.0-rc.9.md)
are mirrored in `CHANGELOG.md`.

See the [versioning
policy](https://github.com/prisma/orm/blob/main/docs/oss/versioning.md).
**Merging this PR ships the release:** `Publish to npm` publishes
`8.0.0-rc.9` under `latest`, creates a matching GitHub pre-release using
the committed notes, and then publishes the new base's dev build under
`dev`.

## Testing performed

- Validated all 113 bump files: only package versions, internal
workspace specifiers, and the shipped skill version stamp changed; no
external resolution churn.
- `pnpm install --lockfile-only --frozen-lockfile --ignore-scripts`
- `pnpm lint:skills`
- `pnpm check:upgrade-coverage --mode pr`
- `pnpm check:upgrade-coverage --mode publish`
- `pnpm check:release-notes --mode pr`
- `pnpm check:release-notes --mode publish`
- `git diff --check`
- `pnpm build` — 85 tasks passed.
- `pnpm fixtures:check` — passed after regenerating eight Supabase
contract fixtures to record rc.9.
- No implementation changes; test suites are left to CI.

## Skill update

The release script stamps `skills/prisma-8/SKILL.md` with
`library_version: '8.0.0-rc.9'`. No new behavior is introduced by the
release preparation itself.

## Checklist

- [x] All commits are signed off (`git commit -s`).
- [x] Read `CONTRIBUTING.md`; scoped to one release.
- [x] Generated contract fixtures refreshed and verified; no
implementation behavior changes.
- [x] Title follows the release-specific `chore(release): bump to
<version>` convention.
- [x] Skill update described above.

## Notes for the reviewer

Review the release notes for user-facing changes since `v8.0.0-rc.8`,
especially migration requirements. The version bump and release notes
are separate commits. This PR is not auto-merged; merge is the human
approval gate for publishing.


<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

- **New Features**
- Added reusable SQL filtering capabilities, including composable
predicates.
  - Added PostgreSQL numeric-enum validation constraints.
  - Added upgrade guidance for re-emitting Supabase extension contracts.

- **Bug Fixes**
- Improved attribute diagnostics, enum ordering, numeric default
comparisons, codec behavior, schema-validation messages, and naming
consistency.

- **Breaking Changes**
  - PostgreSQL text-backed enum ordering now follows stored values.
- MongoDB uses native index values and rejects previously ignored
attributes.
  - SQL ORM inputs enforce stricter relation-callback validation.
  - Language-server support requires an explicit schema directive.
  - Reusable SQL filter types now require a namespace argument.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->

---------

Signed-off-by: Steven McClankerton <tatarintsev@prisma.io>
Co-authored-by: Steven McClankerton <tatarintsev@prisma.io>