5 ms·
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 |
by lyxell 2y ago
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.