Database experts, should I use a separate query or a subquery? 🤔

For example, I want to retrieve the author's name for all the posts. Should I add a subquery to fetch that name, or use a separate query to get the names and then map them with the posts? 🧐

Make it complicated 😀
- Create a new col in post with author name
- Add auto update when author model change in a async queue
After that, u can own a lambo 🚀