I was reading about EAV, and what options are available to avoid the pain caused by it, and stumbled upon using JSON in fields.
This mariadb feature page shows an example like,
SELECT name, JSON_VALUE(attr, "$.email.personal") AS email, JSON_VALUE(attr, "$.social.twitter") AS twitter, JSON_VALUE(attr, "$.interests") AS favorite_interest FROM tbl_user_profiles WHERE user_id = "sjohnson";
The JSON is the part that would be a problem, if it was defined in a relational table's schema. Is this really as viable as it looks at first glance?