Motivation

When we denest a column and then handle things like naming collisions, you can end up with very confusing structures when trying to map it all back to the input data.

To aid in this, we could set some helpful string comments/descriptions onto each column's COMMENT in PostgreSQL. Something like:

# Singer Target Postgres

This table was denested from (t0, t1, t2, ...)

This column was denested from (c0, c1, ...)

You can join this back to it's original parent via:

SOME-SQL-HERE

etc.

Suggested Musical Pairing

https://soundcloud.com/hiatus-kaiyote/nakamarra-1