There's a lot to like about the Django ORM. And Django still has it's place. What I'd like is a SQL that creates and consumes a JSON structure as output/input

There's a lot to like about the Django ORM. And Django still has it's place. What I'd like is a SQL that creates and consumes a JSON structure as output/input, and then there wouldn't really be a need to serialize/deserialize anything. Python would be a lightweight wrapper for authentication, error handling, logging, and data processing that couldn't be easily done with SQL. I mean people are trying this, but SQL feels so arcane. If you have tabular data and working with spreadsheets, SQL is great. And the JSON support in postgres is a badly bolted on design choice to force tree style data into tabular data. Instead they should modify SQL to process tree style data as tree style data.