Tip 0: All the power of H2

All the implementations of the SQL language have their own dialects: the syntax and the grammatic can vary among vendors (Oracle, MSSQL, PostgreSQL, MySQL, H2). This app is built on top of the H2 engine. Therefore it supports the H2 dialect.

There are two databases on Jira. The physical (native) database storing the Jira data and the SQL+JQL database: an H2 database instance running on the Jira memory. It is a virtual database because it stores no data. All the tables are empty and they are populated in real-time to resolve the users' queries. The app uses Atlassian's public Java APIs for Jira to achieve this.

This brings all the robustness and functionality of the H2 engine to organizations. You can write really complex SQL queries that are resolved by the H2 engine and use a lot of H2 functions to work with strings, dates, etc.