Support for `joins` or `foreign keys` when exporting to sqlite

simonw / airtable-export

Export Airtable data to YAML, JSON or SQLite files on disk

https://datasette.io/tools/airtable-export

Apache License 2.0

112 stars 15 forks source link

Support for `joins` or `foreign keys` when exporting to sqlite #18

Open kbsali opened 3 years ago

kbsali commented 3 years ago

Hi,

When exporting an airtable db to sqlite, is there a way to query the resulting dataset with joins ? I'm not an expert in sqlite, but I'm guessing it is possible to join 2 tables without having foreign keys defined? But given the format of those foreign keys (eg. ["recqyhKQGTj1HU8Gi"]), I'm not sure if it is possible.

Thanks for possible hints!