Sasha

Correctly builds initial drawer data when clicking "add new" for joins with relationships inside of arrays

PR to https://github.com/payloadcms/payload/pull/9773 Not only implements join field support relationships inside arrays in Postgres / SQLite, but also: * Significantly improves `traverseFields` and the `'join'` case with a raw query...

Adds `idType: 'uuid'` to the SQLite adapter support: ```ts sqliteAdapter({ idType: 'uuid', }) ``` Achieved through Drizzle's `$defaultFn()` https://orm.drizzle.team/docs/latest-releases/drizzle-orm-v0283#-added-defaultfn--default-methods-to-column-builders as SQLite doesn't have native UUID support. Added `sqlite-uuid` to CI.

Previously, if you selected only upload `hasMany: true` field, you would receive an empty arrays always, because the `_rels` table wasn't joined in this case. Fixes the condition to count...

Previously, queries like this didn't work: ```ts const res = await payload.find({ collection: 'polymorphic-relationships', where: { polymorphicLocalized: { equals: { relationTo: 'movies', value: movie.id, }, }, }, }) ``` This...

Fixes https://github.com/payloadcms/payload/issues/10034

This avoids additional file system writes (1 for `await writeFile` and then `npx prettier --write`) instead prettier now formats the javascript string directly. Went from 650 MS to 250 MS...