横向拼接多条sql查询结果返回使用实体接收

Question

 select count(*) cautionLightAmount from cautionlight where ST_Intersects(geom,ST_GeomFromText('${geomWkt}',4326))；select gid cautionLightGids from cautionlight where ST_Intersects(geom,ST_GeomFromText('${geomWkt}',4326)) order by gid；select st_astext(geom) cautionLightGeoms from cautionlight where ST_Intersects(geom,ST_GeomFromText('${geomWkt}',4326)) order by gid；select t2.name cautionLightRoadName from cautionlight t1 left join topo_centerroad t2 on t1.roadid=t2.id where ST_Intersects(t1.geom,ST_GeomFromText('{geomWkt}',4326)) order by t1.gid；比如这四句sql 我想用如下格式接收cautionLightAmount     cautionLightGids    cautionLightGeoms     cautionLightRoadName
          2                                   3                                     2                            line1
由于需要用一个实体接收数十个形如这样的参数，希望可以通过mybatis框架传入一次sql就将所有的结果返回，向各位大佬求教，数据库类型为postgreSQL

Answer 1

一个参考select count(t1.(table的唯一编号)) cautionLightAmount ,t1.gid cautionLightGids,st_astext(t1.geom) cautionLightGeoms,t2.name cautionLightRoadName
from cautionlight t1
left join topo_centerroad t2 on t1.roadid=t2.id
where ST_Intersects(t1.geom,ST_GeomFromText('{geomWkt}',4326)) order by t1.gid;