Another advantage from a performance standpoint is that the data used to generate the JSON output is likely already cached in memory by your database engine. W

Another advantage from a performance standpoint is that the data used to generate the JSON output is likely already cached in memory by your database engine. With SQL Server (and presumably with Postgres) JSON can be indexed in various ways, leading to even more performance gains.