Care to expand on why MySQL < 8 will be problematic for analysts? Anything else than the lack of window function?
CTEs/WITH clause is the other massive one - almost as important as window functions.
Additionally, EXCEPT/INTERSECT support, better EXPLAIN (it's still shit though), much improved REGEXP and JSON support.