Forgot to add DDL for the outer table:
CREATE TABLE materializedInstances (
provider TEXT(2000000000),
instanceId TEXT(2000000000),
packageId INTEGER,
date TEXT(2000000000),
duration INTEGET,
transportType INTEGER,
CONSTRAINT MATERIALIZEDINSTANCES_PK PRIMARY KEY (provider,instanceId)
);
CREATE INDEX 1ab7a7b8a24dce53a34a650587c5bfdabcc785a2 ON
materializedInstances
(packageId,provider,instanceId,date,duration,transportType);
CREATE INDEX sqlite_autoindex_materializedInstances_1 ON
materializedInstances (provider,instanceId);