@samwilson looks like you can load a library to provide a user defined one? i don't *think* i've actually tried this...
@brennen So far, all I've found is docs about loading a user-defined one that can only be used in the WHERE clause, and not for selecting. What I want to do is chop up a field into various parts, and use those parts elsewhere in the query.
@samwilson ah! hmm. how complex is the field?
@brennen hehe, well… it's a filename deep within a JSON field. I've pulled it out of that though (huzza for `json_each()`) and now want to extract a few bits of info out of the filename (e.g. the integer in `/.*No_?([0-9]+).*/`).