It seems like middleware will only run for explicitly called queries, not nested ones, correct?

At the moment yes. we have a workaround in this issue that you can check out 🙂