Feature Request: Support nested arrays

[jvacek]

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"

[willtho89]

@jvacek 1NF tables seems to be the most easiest way to implement it, but the file gets big easily on highly nested serializers. The 2NF approach seems more reasonable but I have never worked on linked sheets.

I'll leave this open in case someone wants to give it a shot.

[rptmat57]

This would be a really nice feature to have.
I use drf-flex-fields to expand related fields on demand, and it just breaks when trying to export in XLSX after expanding any field. this would probably fix the issue