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, storeCode
    FROM shipment_header
    WHERE 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"
  }
]