Alex Garcia

SQLite Blog

I have a really gnarly workaround for working with CSV strings in SQLite: you can use dumb search and replace to turn them into JSON, then use the SQLite json table-valued functions to read values fro them.

This will break horribly if a CSV file has any escaped double quotes in its values, but it works for very simple CLV strings.

I wrote this trick up here: https://simonwillison.net/2022/Aug/21/scotrail/#assembling-sentences

Purpose-built for displays of data