In this example, the JSON data in the "json_col" column is compressed using the JSON_COMPRESS function. The compressed data is uncompressed using the JSON_DECOMPRESS function.
CREATE TABLE temp ( id INTEGER, json_col JSON(1000) CHARACTER SET LATIN COMPRESS USING JSON_COMPRESS DECOMPRESS USING JSON_DECOMPRESS);