...
SQL+JQL can export query results with REST+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.and CSV document formats:
Click on the link to copy the URL to the clipboard.
If the saved queries have parameters, then you can append to the URL. Parameters start with the param prefix followed by a numerical sequence starting by the 1 number.
¶m1=…¶m2=…¶m3=…