Difference between query modes

const result1 = await db.query.notifications.findMany({
  where: eq(notifications.guild_id, interaction.guildId),
  with: {
    group: true,
  },
});

const result2 = await db
  .select()
  .from(notifications)
  .limit(1)
  .where(eq(notifications.guild_id, interaction.guildId))
  .innerJoin(groups, eq(notifications.group_id, groups._id))
  .execute();