How do relational queries work under the hood?

const post = await db.query.posts.findFirst({
  with: {
    comments: true,
  },
});