The Scanyp grid widget permits to show the result of a code query in your custom page.
The grid widget sample is accessible from the $ScanypInstallFolder/extnsions/GridSample.
Here's a sample of integrating the grid in the extension:
The queries could be managed from the Admin->Queries tab.
You can use an existing query in the extension or create a new query from the admin area.