Although you can call the function directly, JSON_DECOMPRESS is often used with the DECOMPRESS USING phrase to uncompress table columns. In the following table, the JSON data in the json_col column 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);