Have a look if we can write a neat HSQL query. The SQL should look something like this:

select * from SPACEPERMISSIONS sp join SPACES s on sp.SPACEID = s.SPACEID
where (sp.PERMUSERNAME = 'admin'
or sp.PERMGROUPNAME in ('confluence-user', 'confluence-admins'))
and sp.PERMTYPE = 'VIEWSPACE'