What’s new with JSON in PostgreSQL v14

PostgreSQL v14 introduces significant enhancements, particularly in handling JSON data, building on its historical improvements since JSON's initial introduction in v9.2. The latest version simplifies data manipulation by allowing JSON data to be accessed and updated using subscripts, aligning with conventional methods of JSON handling. This development makes querying and updating JSON data more intuitive, reducing the reliance on the previously necessary jsonb_set function, although the latter still offers certain advantages like preventing the creation of nonexistent columns. Despite these improvements, subscripting does not fully replace traditional methods, as it does not always leverage indexes and lacks some flexibility. These advancements reflect PostgreSQL's ongoing evolution in efficiently managing JSON data, leaving room for future enhancements like better index integration or dot notation for JSON access.