After going through every pattern this is also my favorite one. While it can add some perceivable latency if you have many levels of depth, it is usually a lot

After going through every pattern this is also my favorite one. While it can add some perceivable latency if you have many levels of depth, it is usually a lot lighter on CPU and memory than one big query. The reason I really like it is because it is very easy to strongly type results coming from a single table, and processing the data in your application code allows you to keep the typings through the process of stitching everything back together.