NIf your frontend ends up doing the joins won’t that have an even bigger impact on speed?
NLess network calls is generally good
NWell a BFF can have dedicated routers for specific screens, if the problem is you're querying more than you need, you could query exactly what's needed on a dedicated router/procedure
NIf you're querying exactly what you need and the query is slow, then optimise the DB 