Custom extractor for PhpStorm to extract database tables as JSON

JSON-JavaScript.json.js

function eachWithIdx(iterable, f) { var i = iterable.iterator(); var idx = 0; while (i.hasNext()) f(i.next(), idx++); }
function mapEach(iterable, f) { var vs = []; eachWithIdx(iterable, function (i) { vs.push(f(i));}); return vs; }
function output() { for (var i = 0; i < arguments.length; i++) { OUT.append(arguments[i]); } }

var rows = [];
eachWithIdx(ROWS, function (row) {
    var obj = {};
    eachWithIdx(COLUMNS, function (col) {
        var value = FORMATTER.format(row, col);

        if (value.toLowerCase() === "null") {
            value = null;
        }

        try {
            value = JSON.parse(value);
        } catch (e) { }

        obj[col.name()] = value;
    });

    rows.push(obj);
});

output(JSON.stringify(rows, null, 4));

Open a database table in PhpStorm, in the dropdown of formats to export as click on "Go to Scripts directory".
In "Extensions -> Database Tools and SQL -> data -> extractors" you can create a file called JSON-JavaScript.json.js and paste the above code in. Now you can extract the data as JSON.