LINK ISSUE

Function LINKISSUE() creates a link to your issue, so you can easily click on it and open issue in your Jira.

Select LINKISSUE(i.`KEY`) as `Issue`
from ISSUE i
Where JQL='reporter=currentUser()'

You can link issue KEY in any complex query that you want to use (like it's shown in Video example below).