Laravel: virtualAs(), virtual column extracted from JSON field

migration_file.php

<?php

class SomeMigration {
  
  public function up() {
    Schema::table('json_data', function(Blueprint $table) { 
       $table->string('email', 100)
         
         // here we deine the virtual column for the json_data table which will be just a column view
         ->virtualAs("json_unquote(json_extract(json, '$.email'))");
      
         // here we can define index for that column
         ->index();
    });
  }

}

tinker_debug_sql.php

<?php
// tinker
>>> DB::table('json_data')->select('json->email')->debug();

// output
>>> select json_unquote(json_extract(json, '$.email')) from json_data;