PostgreSQL 17 — JSON upgrades making JSON querying easier than ever

PostgreSQL 17 introduces powerful upgrades for JSON handling, including the new JSON_TABLE() function and enhanced JSON path querying.
This video explains how these features simplify querying, filtering, and transforming JSON documents directly within SQL.
📖 Read the full blog post: https://abcloudz.com/blog/json-improv...
📺 Part of the featured playlist:    • PostgreSQL 17 — New Features Overview  

0:00 PostgreSQL 17 JSON Improvements — Overview
0:50 What is JSON
1:48 JSON_TABLE(): Making Life Easier
3:05 JSON_TABLE(): Syntax
4:33 Example 1 - PASSING, FOR ORDINALITY, PATH, EXISTS
6:04 Example 2 - NESTED
7:08 Example 3 - Querying JSON from a table