JSON mode for sql query pane

Nobody has claimed this yet.

I often have to construct fairly large JSON objects in postgres.

This usually happens if I have to pipe some data into a template or returning some data from an API. Postgres JSON support has become good enough, that it is preferable to assemble (and serialise) the whole object in PG, over getting the data from the db and constructing the object "by hand" one layer up.

It would be great to have a mode where the result is automatically pretty printed and syntax highlighted. These queries only have one row and one column.

Maybe you could switch automatically to a JSON view if only one row with one column is returned and this column contains json data.

I don't know if any other special mode would make sense - maybe XML, but who uses that anymore ; )

Anyway, right now the turnaround time for editing a query like this is quite high, since I have to copy the result into an editor and pretty print it there. But I think this style of query will only become more commonplace and having good support for this would make a great feature

Start by locating Postico’s SQL query pane and the result-rendering path. Review how one-row, one-column PostgreSQL results are displayed; done means JSON results can be automatically pretty-printed and syntax-highlighted, with the switching behavior defined for the proposed JSON mode.

Written by the indexing model from the issue text.