Forena[1] is a Drupal module that has the following features:
1. Connect to any relational database with a PDO supported database (SQLite, MySQL, MS SQL, etc).
2. Write SQL to create tabular reports or charts in SVG
This is not a solution for everyone but works well for me because I use Drupal to store meta data about the reports and graphs I created using Forena
Yes I am aware of the recent security issues with Drupal.
1. Connect to any relational database with a PDO supported database (SQLite, MySQL, MS SQL, etc). 2. Write SQL to create tabular reports or charts in SVG
This is not a solution for everyone but works well for me because I use Drupal to store meta data about the reports and graphs I created using Forena
Yes I am aware of the recent security issues with Drupal.
[1]https://www.drupal.org/project/forena