Open
Description
I work a lot with related fields which are 1-M, and currently anything that is an array of objects just gets the whole child json dumped into one field.
It would be nice to have some further "flatification" in one way or another
I can imagine two sensible ways to do this nonsense I'm describing:
- 1NF table: "left-join"ing all the columns into one massive table)
- 2NF multiple sheets: a sheet per every key which holds an array, and dropping just the "row" references back into the "parent"