> isn't a black box of magic

Referring mostly to the query planner - you have no control over it, and you have to dive deep to figure out why it's making certain plans, and how it collects statistics to make these calls. Plus the planner essentially gives up at 6+ joins.

> quite flawed for modern web apps

Try listening to updates on a query.