MySQL 5.7.8+ introduced a native JSON data type with automatic validation and optimised storage, along with JSON functions (JSON_EXTRACT, JSON_SET, etc.) and virtual columns to index JSON fields.
