title: Test OpenSQL statements in the SAP GUI or Eclipse ADT?
body: <p>I am writing an OpenSQL query, including joins and sub-selects, and I am unsure whether it works. To find out, I'd like to run it somewhere, look at the results, then change it, it an iterative way.</p>
  
  <p>Traditional tools like transactions <code>SE16</code> or <code>SQVI</code> don't help, because they have too little functionality (only one table, only joins but no sub-selects, etc.). Other threads with similar questions, <a href="https://it.toolbox.com/question/execute-sql-query-in-sap-020614" rel="nofollow noreferrer">like this one</a> remained unanswered.</p>
  
  <p>Of course, I could write a report or a unit test, paste my code there, and run it, but this makes the iterative cycle so slow because I need to change input and output data formats all the time. Optimal solution would be something like the SQL Console in SAP HANA Studio, but for OpenSQL instead of native SQL.</p>