It's generally not very difficult to get SQL query results in JSON rather than tabular format and then feed that to your favorite charting tools.
FnordMetric aims to fix that by extending standard SQL; it allows you to express the data query and the chart specification in a coherent fashion (SQL).