public static String getNewSelectBody(String selectBody, String alisa, String asAlisa, String escapeSymbol) {
        String[] split = selectBody.split(COMMA);
        StringBuilder sb = new StringBuilder();
        boolean asA = asAlisa != null;
        for (String body : split) {
            final String sa = alisa.concat(DOT);
            if (asA) {
                int as = body.indexOf(AS);
                if (as < 0) {
                    sb.append(sa).append(body).append(AS).append(escapeColumn(asAlisa.concat(DOT).concat(body), escapeSymbol));
                } else {
                    String column = body.substring(0, as);
                    String property = body.substring(as + 4);
                    property = StringUtils.getTargetColumn(property);
                    sb.append(sa).append(column).append(AS).append(escapeColumn(asAlisa.concat(DOT).concat(property), escapeSymbol));
                }
            } else {
                sb.append(sa).append(body);
            }
            sb.append(COMMA);
        }
        return sb.deleteCharAt(sb.length() - 1).toString();
    }
@Test
    void getNewSelectBody() {
        String s = SqlUtils.getNewSelectBody("id,name", "d", null, null);
        assertThat(s).isEqualTo("d.id,d.name");

        s = SqlUtils.getNewSelectBody("`id`,`name`", "d", null, null);
        assertThat(s).isEqualTo("d.`id`,d.`name`");

        s = SqlUtils.getNewSelectBody("id,name", "d", "pp", "`");
        assertThat(s).isEqualTo("d.id AS `pp.id`,d.name AS `pp.name`");

        s = SqlUtils.getNewSelectBody("id AS t_id,name AS t_name", "d", null, null);
        assertThat(s).isEqualTo("d.id AS t_id,d.name AS t_name");

        s = SqlUtils.getNewSelectBody("`id` AS t_id,`name` AS t_name", "d", null, null);
        assertThat(s).isEqualTo("d.`id` AS t_id,d.`name` AS t_name");

        s = SqlUtils.getNewSelectBody("id AS `t_id`,name AS `t_name`", "d", "pp", "`");
        assertThat(s).isEqualTo("d.id AS `pp.t_id`,d.name AS `pp.t_name`");

        s = SqlUtils.getNewSelectBody("`id` AS `t_id`,`name` AS `t_name`", "d", "pp", "'");
        assertThat(s).isEqualTo("d.`id` AS 'pp.t_id',d.`name` AS 'pp.t_name'");
    }