return db
    .select({
      id: contacts.id,
      firstName: contacts.firstName,
      lastName: contacts.lastName,
      number: phoneNumbers.number,
    })
    .from(contacts)
    .leftJoin(phoneNumbers, eq(contacts.id, phoneNumbers.contactId));

return db
    .select({
      id: contacts.id,
      firstName: contacts.firstName,
      lastName: contacts.lastName,
      number: phoneNumbers.number,
    })
    .from(contacts)
    .leftJoin(phoneNumbers, eq(contacts.id, phoneNumbers.contactId));

typeof result.users[0].posts === "string"  // true

typeof result.users[0].posts === "string"  // true

const result = await db.query.users.findMany({
    with: {
        posts: posts.content  // <----only the first post should be fetched and only a string should be returned             
    },
});

const result = await db.query.users.findMany({
    with: {
        posts: posts.content  // <----only the first post should be fetched and only a string should be returned             
    },
});