Implement Spoonbill-like table improvements

[jpmckinney]

Flatterer has some options like:

• pushdown=["ocid", ...]
• inline_one_to_one=True
• schema="path" (column order)

[yolile]

We could also offer the sqlite export option, which saves external advanced analysts/users some steps

[jpmckinney]

Has anyone requested SQLite?

[yolile]

Not yet, but I though it could be useful for us in case we want to start creating notebooks to calculate indicators with data from the registry for external users. For example, MAPS, or SPP related ones.

[jpmckinney]

Sounds good. I created #387 since this issue can be closed without doing SQLite.

[yolile]

pushdown=["ocid", ...]

This one is important, as otherwise the links are not unique across different files per year, for example. One user from the UK requested this (or, actually, mentioned the issue about not being able to link all fields back together if the _links columns are not unique). I tested it, and we should use pushdown=["ocid", "id"], and with that, we should cover all the arrays and their children. It would include pushing down some columns to tables where they are not necessary, but this is fine.

[jpmckinney]

Good catch! Please make the change.