From the archive
Friday, 16 October
Folded from 14 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
From JSON Strings to Typed Columns
Shows how to infer a typed schema from a VARCHAR JSON column directly in SQL with json_group_structure, avoiding a COPY-to-file round trip. Also covers extracting fields with the JSON operators.