DuckDB has a json_extract()
function that extracts JSON from a JSON document. DuckDB also has a function called json_extract_string()
that does a similar thing, but extracts its value as a string.
This article takes a look at these two functions side by side.
Continue reading