insert into profile_facts select id, key, value, value_type from read_ndjson_auto('data/tables/profile_facts.ndjson.gz', ignore_errors = false);

insert into companies select id, name, url, kind from read_ndjson_auto('data/tables/companies.ndjson.gz', ignore_errors = false);

insert into writing_sources select id, name, url from read_ndjson_auto('data/tables/writing_sources.ndjson.gz', ignore_errors = false);

insert into tags select id, name from read_ndjson_auto('data/tables/tags.ndjson.gz', ignore_errors = false);

insert into work select id, company_id, role, start_year, end_year, summary from read_ndjson_auto('data/tables/work.ndjson.gz', ignore_errors = false);

insert into projects select id, title, url, summary, status, visibility from read_ndjson_auto('data/tables/projects.ndjson.gz', ignore_errors = false);

insert into writing select id, title, url, source_id, published_date, published_year, published_precision, summary, external from read_ndjson_auto('data/tables/writing.ndjson.gz', ignore_errors = false);

insert into links select id, label, url, kind from read_ndjson_auto('data/tables/links.ndjson.gz', ignore_errors = false);

insert into pages select id, title, url, markdown_url, summary, kind from read_ndjson_auto('data/tables/pages.ndjson.gz', ignore_errors = false);

insert into cats select id, name, caption, alt, image_key, orientation from read_ndjson_auto('data/tables/cats.ndjson.gz', ignore_errors = false);

insert into skills select id, name, category, weight, evidence from read_ndjson_auto('data/tables/skills.ndjson.gz', ignore_errors = false);

insert into entity_tags select entity_kind, entity_id, tag_id from read_ndjson_auto('data/tables/entity_tags.ndjson.gz', ignore_errors = false);

insert into skill_evidence select skill_id, entity_kind, entity_id, label from read_ndjson_auto('data/tables/skill_evidence.ndjson.gz', ignore_errors = false);