ChartPlugin with tables generated by DatabasePlugin/SqlPlugin? Any chance?

Hi, is there any way to create a graphical output of data generated by sql plugins? I use databaseplugin to render a table with some actual data stored in db and it would be nice to have an option to draw some kind of progress graphically. Is that possible?

Thanks

Jindrich

Answering myself:

You need to put DATABASE_SQL macro inside EXPAND macro and set the scope to current topic. Works somehow like eval in bash. You need to 'escape' all the % with $percent and " with $quot. Looks like this:

%EXPAND{"$percentDATABASE_SQL{description=$quotsomequery$quot sql=$quotSELECT * FROM sometable;$quot}$percent" scope="CurrentWikiPageName"}%