How does one convert a JSON string value to a VARCHAR value (excluding quotes) in H2?
I have a H2 database (version 2.2.220) with data in a JSON column; I need to migrate the column via a SQL script so that the data is in a conventional relational database structure. The main stumbling block is that…