Too bad mysql doesn't even have materialized views - its not a good combination with a json only situation, but you clearly are suffering through that, good luck :) probably etl it to clickhouse and move on.

Could always try and dump to GCP/Parquet/json and use duckdb/bq to just query it all.