Table 1 shows the output for my JSON object. Table 1: Default Table Format from OPENJSON for a Single JSON Object This works as long as the column names in the WITH clause match the object’s property ...

is a format that is very popular with developers and is the basis for document databases like MongoDB. Kincaid said that PostgreSQL 17 now supports JSON tables, which is a major step forward.

These new features include extended syntax, aggregation functions, and JSON table functions ... as using a simple declarative configuration format. There’s also been buzz about GraalVM.