Automatically convert JSON to string

[simonw]

This enrichment fails with an error:

function enrich(row) {
  return row.Counties.split(",")
}

Error binding parameter 1: type 'list' is not supported

This works:

function enrich(row) {
  return JSON.stringify(row.Counties.split(","))
}

It would be good if the first one automatically encoded as JSON rather than dying with an error.

[simonw]

Output column can be of type text, integer or float.

Should check what comes back from the function.

• If output column is an integer and the return value is a string that can be turned into an integer, do that
• Same for float
• If it's a string and the output column is a string, change nothing
• If output column is a string and return value is something else, JSON encode it