Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Editing query nested in another edit. Searches nested fields by wrapping another query. nested field objects are searched as if they were separate documents when a nested query is used.

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data.