In this example, how many individual requests are done against the DB?

const author = await context.prisma
      .post({
        id,
      })
      .author()

Does it first query the post, and then the author? Or does it batch them and join?

This is one query. In essence the client is a query builder and the actual execution is delayed to the latest moment possible.

Ok great, thanks