自定义sql查询

{
    "columns": {
      "parentName": {
        "fieldSort": 9999,
        "tableId": 1,
        "dataType": "varchar",
        "title": "上级栏目",
        "remark": "用于搜索",
        "guidMethod": "None",
        "isRequired": true,
        "isSearch": true,
        "isData": false,
        "editPropertie": {
          "showMethod": "text"
        },
        "pagePropertie": {
          "showMethod": "text"
        },
        "filter": {
          "method": "custom",
          "isMust": false,
          //"sql": " and parent_id in (select menu_id from bo_sys_menu where menu_name like CONCAT('%',@parentName,'%'))",
          //如果 sqlCustom 没找到,使用 sql     sqlserver   mysql  oracle sqlite  SqlCustom
          "sqlCustom": {
            "mysql": " and parent_id in (select menu_id from bo_sys_menu where menu_name like CONCAT('%',@parentName,'%'))",
            "oracle": " and parent_id in (select menu_id from bo_sys_menu where menu_name like '%'||@parentName||'%')",
            "sqlserver": " and parent_id in (select menu_id from bo_sys_menu where menu_name like '%'+@parentName+'%')"
          }
        },
        "field": "parentName",
        "name": "parent_name",
        "alias": "parent_name",
        "isDate": false,
        "isPrimary": false,
        "isIdentity": false,
        "maxLength": 50
      }
    }
  }