Flat Table gadget
Since the 6.4.0 version is possible to add SQL+JQL flat tables to Jira Dashboards and Confluence pages via the built-in gadget. It is intended from easy data displaying on a table as it does not require any other app installed.
Search for the SQL+JQL Flat Table gadget and add it to a Dashboard:
The most important configuration parameter is SQL. You can type or copy&paste there any SQL+JQL query.
From the 7.12.0 version, the SQL is no longer necessary to save the query previously.
The query results will be displayed on a flat table with scroll bars if the content exceeds the gadget view.