Prisma isn't doing joins.

model rules {
    id          String   @id @db.Char(16)
    name        String   @db.VarChar(255)
    object_id   String   @db.Char(16)
    object      objects  @relation(fields: [object_id], references: [id])
}

model objects {
    id            String    @id @db.Char(16)
    original_id   String?   @db.Char(16)
    rules         rules[]
}

const rule = await prisma.rules.findFirst({
    relationLoadStrategy: 'join',
    select: {
        name: true,
        object: {
            select: {
                name: true,
            },
        },
    },
});

prisma:query SELECT `t0`.`id`, `t0`.`name`, `t0`.`object_id`, (SELECT JSON_OBJECT('name', `t1`.`name`) FROM `createdb`.`objects` AS `t1` WHERE `t0`.`object_id` = `t1`.`id` LIMIT ?) AS `object` FROM `createdb`.`rules` AS `t0` LIMIT ?
Query: SELECT `t0`.`id`, `t0`.`name`, `t0`.`object_id`, (SELECT JSON_OBJECT('name', `t1`.`name`) FROM `createdb`.`objects` AS `t1` WHERE `t0`.`object_id` = `t1`.`id` LIMIT ?) AS `object` FROM `createdb`.`rules` AS `t0` LIMIT ?
Params: [1,1]