MySQL 8 Geospatial Queries, MakeEnvelope Workaround?
There is clearly no work around for this issue.


MySQL can't do this operation (and many others) on a geographic srs.
You can't reproject in MySQL.


Oracle MySQL doesn't want to compete with Oracle Spatial. So you're SOL. MariaDB is currently behind MySQL in GIS too and it's a low-priority item for them. Either reproject to something Web Mercator and do Cartesian bounding box stuff, or PostgreSQL and PostGIS, which can do geographic bounding boxes, and on an index at that. And, also ST_Transform from one SRS to another.

PostGIS is the goto solution for GIS.