Its major tech features:

Dynamic tables: empty tables populated in real-time with Jira REST services
Asynchronous engine: the engine is able to break the SQL query into small pieces running in parallel and wait for the remote web services to be completed before continue until the required data are received over the network.
Scalable architecture: it grows up with the user base running on the user’s local hardware lacking a third-party server acting as bottleneck.
Data privacy & security: no data are shared with any third-party server and the user base and permissions are inherited from the Jira configuration.
Outstanding integration: it looks and feel like a real relational database. Just like the missing JIra database in cloud environments.
Multi datasource: it supports Jira and other data sources like Google sheets, CSV, XML, etc.
Industry-standards: it brings all the power of the SQL language to the enterprise.
Read-only: Only SELECT is supported against Jira. INSERT, UPDATE and DELETED are not allowed.
Write-once run everybody: SQL queries can be safely shared with other users as the data are fetched from Jira taking into consideration the current user’s permission.