SQLite how to store translations
I ended up using a separate table to hold translation because maintaining the custom functions and translation blob is a non necessary complexity and is not a portable solution.

CREATE TABLE IF NOT EXISTS Route (
  id integer PRIMARY KEY UNIQUE AUTOINCREMENT NOT NULL,
  name text NOT NULL,
  nameLocalizationId INTEGER REFERENCES Localization(id)
);


The localization table have 3 columns: 

CREATE TABLE IF NOT EXISTS Localization (
    id INTEGER NOT NULL,
    language TEXT NOT NULL,
    text TEXT NOT NULL
);



id is the translations id (its possible to have multiple rows with same id), 
language is the BCP 47 language tag, 
text is the localized string.