>Expecting frontend devs to write efficient SQL queries This just isn't a problem for most modern stacks. You're using an ORM and not writing SQL which isn't

>Expecting frontend devs to write efficient SQL queries This just isn't a problem for most modern stacks. You're using an ORM and not writing SQL which isn't any harder than GraphQL or Rest endpoints. And, for better or worse, there's not that much need to write efficient SQL because servers are so fast these days. The target you need to hit is something like "one of my filter conditions has an index" and things will usually be fine.