How do you use COLUMN_JSON with COLUMN_GET on dynamic columns in MariaDB?

When I do the following query;

SELECT name, COLUMN_GET(attr, 'appearance' as char) as 'attributes' from items;

I see the 2 columns including the blob data with the weird formatting.

Is it possible to include the COLUMN_JSON function to format the data inside of the select query?