Hi @mr.engineer ,
as per our requirements, MySQL is no longer supported as a DBMS for sonarqube.
Also i have seen that you already raised a similar topic here, so it would be great to have this in one place. Apart from that i can already give you the same answer as Cameron on this. The Database Schema is constantly changing and it would be a bad idea to try to extract information from the database without having a look at every migration that will come with an update. You are better off using our API to extract information about code coverage (API endpoint api/measures/component).
Here is an example query via curl assuming you have a component called test and your sonarqube server is on localhost:9000 with the credentials admin:admin :
curl -u admin:admin "http://localhost:9000/api/measures/component?additionalFields=metrics&component=test&metricKeys=coverage%2Cnew_coverage"