in SQLite, is list or array type available?

SQLite does NOT have a built-in array data type. You can store a serialized representation of your array in a TEXT column. This could be a comma-separated list, a JSON array, or any other format that suits your needs.

comma-separated list

CREATE TABLE MyTable (
    id INTEGER PRIMARY KEY,
    my_array TEXT
);

INSERT INTO MyTable (my_array) VALUES ('element1,element2,element3');

JSON array

CREATE TABLE MyTable (
    id INTEGER PRIMARY KEY,
    my_json_array TEXT
);

INSERT INTO MyTable (my_json_array) VALUES ('["element1", "element2", "element3"]');