By frontend JOINs I mean backend APIs with so little regard to the client that the client needs to over-fetch data and perform JOINs/GROUP BYs in the client.

Very common in companies that keep their backend and frontend teams separate or companies with very dogmatic backend people.