I've solved some days in past years with sqlite + enough awk to transform the input into something that can be imported into a table. It can be a fun challenge.
I realized when solving todays problem that SQLite’s
json_each("[" || T.c1 || "]")