能不能将dsl转为sql，我看dsl支持在嵌套子聚合里限制每个聚合的大小，sql有没有办法做到这一点，大佬有研究没？

[PandyYang]

例如这种嵌套子聚合，用sql的话是不是不好搞？
官方文档如下：https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html

  "aggs": {
    "dimtimeyear": {
      "terms": {
        "size": 10,
        "field": "dimensions.time.year",
        "order": {
          "_term": "asc"
        }
      },
      "aggs": {
        "dimtimemonth": {
          "terms": {
            "size": 10,
            "field": "dimensions.time.month",
            "order": {
              "_term": "asc"
            }
          },
          "aggs": {
            "dimtimeday": {
              "terms": {
                "size": 10,
                "field": "dimensions.time.day",
                "order": {
                  "_term": "asc"
                }
              },
              "aggs": {
                "dimtimeweek": {
                  "terms": {
                    "size": 10,
                    "field": "dimensions.time.week",
                    "order": {
                      "_term": "asc"
                    }
                  }