Sasha

perf(db-mongodb): use aggregations for relationship querying

1

Uses lookups for relationships querying (`where { relationship.name }`) of subquerying. Before, whenever we needed to query by a property from another document, we did this: ```ts const result =...

fix(drizzle): expose db.drizzle.$client type

1

According to Drizzle[ 0.34.0](https://github.com/drizzle-team/drizzle-orm/releases/tag/0.34.0) change However, currently we do not expose this type Only with SQLite the adapter itself had it, but this PR includes it to the declaration statement....

User can publish during Autosave

2

### Link to reproduction _No response_ ### Payload Version 3.0.0-beta.37 ### Node Version 20 ### Next.js Version 14.68canary ### Describe the Bug A user can save a document during autosave....

fix: `getPayload` generate import map only in Next.js, move `ws` dependency to `@payloadcms/next`

4

After the change with removing `getPayloadHMR`, we do generate import map even outside of Next.js, which leads to errors when using in a project without it:  Also, the `ws`...

Fixes errors when having joins with versions +drafts on `hasMany: true` relationships. Removes `joinQuery` overhead if we don't need it for the current operation. Right now, in all adapters we...

Ensures `sanitizeRelationshipIDs` works properly in any case Skips ObjectID creation errors to not fail with outdated data to the schema.

feat: add Payload SDK package

4

Adds Payload SDK package, which can be used to query Payload REST API in a fully type safe way. Has support for all necessary operations, including auth, type safe `select`,...

- Uses `pagination: false` where we don't need `totalDocs`. - in `preview/route.ts` uses `depth: 0`, select of only ID to improve performance - in `search` uses `select` to select only...

### What? Previously, using Postgres, select fields with `hasMany: true` weren't clearable. Meaning, you couldn't pass an empty array: ```ts const updatedDoc = await payload.update({ id, collection: 'select-fields', data: {...

feat(db-sqlite): add `autoIncrement` option

3

### What? Exposes ability to enable [AUTOINCREMENT](https://www.sqlite.org/autoinc.html) for Primary Keys which ensures that the same ID cannot be reused from previously deleted rows. ```ts sqliteAdapter({ autoIncrement: true }) ``` ###...