title: AEM/CQ: UI for one-off JCR-SQL / SQL2 / XPath queries with tabular output?
body: <p>I am doing a little usage research in our AEM installation. I would like to find all instances of a component and see what value they have for a certain configuration option. So basically, I want to select the <code>title</code> and <code>myOption</code> properties from all nodes with <code>sling:resourceType</code> <code>myComponent</code>.</p>
  
  <p>I believe the JCR-SQL2 query would be:</p>
  
  <pre><code>SELECT [title], [myProperty] FROM [nt:base]
  where [sling:resourceType] like 'path/to/my/component'
  </code></pre>
  
  <p>My problem is, I can't find a UI in which to run this query.</p>
  
  <ul>
  <li><p><strong>The CRX:DE Query tool</strong> (CRX:DE > Tools > Query) accepts XPath or SQL2, but <strong>only shows me the path to the matching nodes.</strong> Sure I can click on each one to zoom to that node, but that's tedious. I want a tabular output with title and property value.</p></li>
  <li><p><strong>The Query Builder Debugger</strong> (<code>/libs/cq/search/content/querydebug.html</code>) <strong>uses its own URL-based query syntax and only outputs JSON.</strong> I recreated the query in terms of URL parameters...</p>
  
  <pre><code>property=sling:resourceType
  property.value=path/to/my/component
  p.hits=selective
  p.properties=title myProperty
  p.limit=-1
  </code></pre>
  
  <p>... But I still don't want to write code to parse the JSON and display a table.</p></li>
  <li><p>I understand that I could write a class / component to display this but again, this is a one-off query and I am just digging around. I'd prefer not to have to write Java, JS, or JSP just to send and display this query.</p></li>
  </ul>
  
  <p>So my question is...</p>
  
  <p><strong>Is there another query UI buried somewhere in CQ that lets me put in one-off JCR-SQL / SQL2 / XPath queries with columns specified, and get a tabular output, the way you would with a SQL prompt or tool?</strong></p>
  
  <p>I would settle for a query builder incantation to produce pretty-printed JSON, so I could at least eyeball the JSON results.</p>