any blogs/books you'd recommend on schema & query design? it honestly surprises me that these coding-focused models can't look at a schema; look at how data is being queried; reason about the use case for the data; and help prioritize solving for the most likely bottlenecks to scaling the underlying data services.

https://learn.microsoft.com/en-us/sql/relational-databases/s...

This one is a classic for MSSQL, most of it is applicable on postgres.