Page Comparison

...

select
       key(JQL.issue) as "Issue",
       cf(JQL.ISSUE, 10004) as "Sprint",
       cf(JQL.ISSUE, 10006) as "Story Point" 
from 
       JQL
where 
      JQL.query ='reporter = currentUser()'

Writing queries independent of the Jira instance

Many organizations have different environments for their life cycle (development, staging, production, etc). And the custom field ids can be different in each instance. However, it is possible to re-write the query above to be use the custom field names instead of their ids. See how:

...

select 
        * 
from
	(select 
		cfd1.id as "Sprint Id", 
		cfd2.id as "Story Points Id"
	from 
		issuecustomfielddefinitions cfd1 
		   join
		issuecustomfielddefinitions cfd2 
	where 
		cfd1.name = 'Sprint' 
		   and
		cfd2.name = 'Story Points')
	join
	(select *
	   
	from
		JQL
	where
		JQL.query = 'project SSP'
	)

It's almost done. In the query above there are not join constraints either. This will build all the combinations (MxN) again. However, M is 1 and N are all the records (issues) of the JQL. Therefore, there are performance drawbacks and it will perform good. 

Simply, extract the custom fields value from the issue obects (third column) by using the CF() function:

select 
        key(Issue) as "Issue",
        cf(Issue, "Sprint Id") as "Sprint",
        cf(Issue, "Story Points Id") as "Story Points"
from
	(select 
		cfd1.id as "Sprint Id", 
		cfd2.id as "Story Points Id"
	from 
		issuecustomfielddefinitions cfd1 
		   join
		issuecustomfielddefinitions cfd2 
	where 
		cfd1.name = 'Sprint' 
		   and
		cfd2.name = 'Story Points')
	join
	(select
                issue
	from
		JQL
	where
		JQL.query = 'project = SSP'
	)