The application provides you with 3 ways of building queries:
Console
Visual query builder
Query Library
Depending on your SQL writing query skills you can easily choose the most comfortable way to write query.
For advanced users of SQL language, it might be more comfortable to use our Console, where you have an opportunity to write your own query. More information about the specification of SQL used in the console you can find here (put a link on technical documentation about SQL version that we use).
If it's more comfortable for you to build a query in a more visual way, where you can see all relative tables of Data from your Jira - Visual Query Builder will help you to construct it in an easy and fast way.
For beginners, or those who need to get simple data from Jira- Query Library will be a good assistant to choose the necessary query and run it without knowledge of SQL language.