SQL+JQL can export query results with JSON document format via the HTTP protocol with basic authentication (Jira username & password) which allows seamless integration with third-party tools like MS Excel, MS PowerBI, etc.