SQL查询，直接生成json结果

场景

• 可直接将查询结果，调用post请求发送json数据
• 可直接根据json结果，进行序列化处理

SELECT JSON_ARRAYAGG(JSON_OBJECT('id', id,'code', `code`,'primaryWaybillCode', primaryWaybillCode,'carrierCode', carrierCode,'storeCode', storeCode)) AS result
FROM (SELECT id, `code`, primaryWaybillCode, carrierCode, storeCodeFROM shipment_headerWHERE actualShipDateTime>='2025-10-09' and actualShipDateTime<'2025-10-10'   AND queryTime IS NULL and primaryWaybillCode is not null and primaryWaybillCode!=''and carrierCode not in('120001552') and carrierCode='ZTO' LIMIT 50
) AS subquery;

结果

[{"id": 35072065,"code": "code001","storeCode": "旗舰店","carrierCode": "ZTO","primaryWaybillCode": "SF329944888585"},{"id": 35073013,"code": "code002","storeCode": "旗舰店","carrierCode": "ZTO","primaryWaybillCode": "SF329944888585"}
]