backend/sql/ingestion/02_create_words.sql

CREATE TABLE words AS
SELECT
    word_ix::BIGINT AS word_ix,
    lang,
    lexeme,
    sense
FROM read_csv_auto(?, delim='\t', header=false, columns={
    'word_ix': 'BIGINT',
    'lang': 'VARCHAR',
    'dummy': 'INTEGER',
    'lexeme': 'VARCHAR',
    'sense': 'VARCHAR'
})