I’m allowing myself to convert the data to a csv and read it using ’.mode csv’.
I realized when solving todays problem that SQLite’s
json_each("[" || T.c1 || "]")
Is useful for parsing comma separated rows into (row, col)-pairs as well.