You can check out https://www.driftingruby.com/episodes/virtual-columns-in-mysql and https://www.driftingruby.com/episodes/virtual-columns-with-json-data-types on Virtual Columns.