I'm not sure exactly what you're seeing but I do see a trend of Postgres products focussed on the frontend app developer e.g. Supabase, Neon.

Those developers are used to dealing with objects and types and SQL is a step further removed from what they're comfortable with.