[FEATURE]: drizzle-zod with a join syntax

[cybercoder-naj]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

Not every request in a backend server is a simple database read. Some involve complex operations like joins.

const users = pgTable('users', {
  id: t.serial().primaryKey(),
  name: t.string()
});

const posts = pgTable('posts', {
  id: t.serial().primaryKey(),
  user: t.string().references(() => users.id);
  content: t.string()
});

const userPosts = createSelectSchema(users, { ...joinedWith(posts) });

The above snippet is only an example. Such a feature would be great to use!