zenstackhq/zenstack v3.9.7

ZenStack Release v3.9.7

on GitHub

What's Changed

Fixes

• Fixed a TypeScript "Type instantiation is excessively deep and possibly infinite" (TS2589) error when passing a generated XxxUpdateArgs / XxxUpsertArgs type directly into update / upsert on a schema with many-to-many relations #2778
• Fixed relation queries with orderBy, skip, take, cursor, or distinct failing with column "$$tN"."id" does not exist when the relation's id/foreign-key or ordering field is omitted and the relation has a nested include #2830

Performance

• Access policy SQL on PostgreSQL is now index-friendly #2851:
  • field == auth().id on a @db.Uuid column no longer casts the column to text. The same applies to text-like native types (@db.Text, @db.VarChar, @db.Char, @db.Citext)
  • Collection predicates (?[...], ![...], ^[...]) compile to EXISTS / NOT EXISTS instead of a correlated count(1) > 0 aggregate
  • relation == auth() (and relation == relation) now compares the foreign-key column directly when the relation owns it, instead of running a correlated subquery into the related table

Full Changelog: v3.9.6...v3.9.7