It would be nice to have an option, for example "pretty", which enable special output mode for the to_json function. In the mode, produced JSON string will have easily readable representation. For example:
There are at least two use cases:
- Exploring content of nested columns. For example, a result of your query is a few rows, and some columns have deep nested structure. And you want to analyze and find a value of one of nested fields.
- You already have an JSON in one of columns, and want to explore the JSON records. New option will allow to do that easily without copy-past JSON content to an editor by combining from_json and to_json functions.