DuckDB: Querying JSON files as if they were tables

2023-03-03Laurens Kuiper TL;DR: We’ve recently improved DuckDB’s JSON extension so JSON files can be directly queried as if they were tables. DuckDB has a JSON extension that can be installed and loaded through SQL: INSTALL 'json'; LOAD 'json'; The JSON extension supports various functions to create, read, and manipulate JSON strings. These functions are similar…