SQLui is a tool that enables the handling of JSON files via SQL commands.
You can also use the SQLui class to optimize the query to JSON files using SQL commands.
reportmaker allows you to define a generic report in xml containing sections,graphs,tables,images.
The data can be retrieved directly with sqlquery.
The report can be exported in various formats (html,xml,rtf,pdf)