[TrispusAttucks]

I'm pretty sure you can load a query result into an [1] in memory table and query that including generated indexes.

[1] https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engin...