I'm glad that you're unblocked.

Note that you can also use the parse_jsonb() function in a SQL query to parse a VARCHAR-style column into a JSONB value. For example, with a hard-coded string value:

parse_jsonb('{"a":1, "b":null}')

https://www.labkey.org/Documentation/wiki-page.view?name=labkeysql

Thanks,
Josh