Work with JSON Data in SQL

Most relational databases today come with built-in support for JSON. You'll find a great range of processing functions and operators needed to handle all CRUD operations. In this lesson, we work with Postgres and walk through creating a table with a JSON column type, how to insert JSON, how to select it out in different formats, and how to use the built-in Postgres JSON functions.