pull_requests: 737050557

This data as json

id node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association repo url merged_by auto_merge
737050557 PR_kwDOCGYnMM4r7n-9 327 closed 0 Extract expand: Support JSON Arrays 101753 Hi, I needed to extract data in JSON Arrays to normalize data imports. I've quickly hacked the following together based on #241 which refers to #239 where you, @simonw, wrote: > Could this handle lists of objects too? That would be pretty amazing - if the column has a [{...}, {...}] list in it could turn that into a many-to-many. They way this works in my work is that many-to-many relationships are created for anything that maps to an dictionary in a list, and many-to-one relations for everything else (assumed to be scalar values). Not sure what the best approach here would be? Are many-to-one relationships are at all useful here? What do you think about this approach? I could try to add it to the cli interface and documentation if wanted. Thanks for this awesome piece of software in any case! :sun_with_face: 2021-09-19T10:34:30Z 2022-12-29T09:05:36Z 2022-12-29T09:05:36Z   f0105cde23452cb4c8a15fc6096154b15d9b7c5a     0 2840c697aa9817462d864ed5f8a7696d749fe039 8d641ab08ac449081e96f3e25bd6c0226870948a NONE 140912432 https://github.com/simonw/sqlite-utils/pull/327    

Links from other tables