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!
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!