I use datasette, datagrip and excel to process sales data. - datasette to surface data via rest to excel (power query) - datagrip to get the data how I want i

I use datasette, datagrip and excel to process sales data. - datasette to surface data via rest to excel (power query) - datagrip to get the data how I want it, the json1 extension is so so much easier to work with than power query and for my use cases extremely fast. This gives you (arguably) the best data grid in the world (excel) but without the horrible experience of building a pipeline in power query that will eventually become too slow and/or randomly crash and hang. I would really, really like an in the box Regex extension so I can create SQLite views without the crazy lengths I have to go with SQL to, for example split a comma delimited list in a field.