Is this:
select value from json_each(readfile('names.json'))
Built in to (standard) sqlite? It's a little unclear from your comment?