@Override
    public NativeQuerySpec<Record> select(String sql, Object... args) {
        return new NativeQuerySpecImpl<>(this, sql, args, DefaultRecord::new, false);
    }
@Test
    public void testNative() {
        database.dml()
                .insert("s_test_event")
                .value("id", "helper_testNative")
                .value("name", "Ename2")
                .execute()
                .sync();

        database.dml()
                .insert("s_test")
                .value("id", "helper_testNative")
                .value("name", "main2")
                .value("age", 20)
                .execute()
                .sync();

        DefaultQueryHelper helper = new DefaultQueryHelper(database);
        QueryParamEntity param = QueryParamEntity
            .newQuery()
            .is("e.id", "helper_testNative")
            .is("t.age", "20")
            .orderByAsc("t.age")
            .getParam();

        {
            Sort sortByValue = new Sort();
            sortByValue.setName("t.id");
            sortByValue.setValue("1");
            param.getSorts().add(sortByValue);
        }
        {
            Sort sortByValue = new Sort();
            sortByValue.setName("t.id");
            sortByValue.setValue("2");
            param.getSorts().add(sortByValue);
        }


        helper.select("select t.*,e.*,e.name ename,e.id `x.id` from s_test t " +
                          "left join s_test_event e on e.id = t.id " +
                          "where t.age = ?", 20)
              .logger(LoggerFactory.getLogger("org.hswebframework.test.native"))
              .where(param)
              .fetchPaged()
              .doOnNext(v -> System.out.println(JSON.toJSONString(v, SerializerFeature.PrettyFormat)))
              .as(StepVerifier::create)
              .expectNextCount(1)
              .verifyComplete();

        helper.select("select id,name from s_test t " +
                          "union all select id,name from s_test_event")
              .where(dsl -> dsl
                  .is("id", "helper_testNative")
                  .orderByAsc("name"))
              .fetchPaged()
              .doOnNext(v -> System.out.println(JSON.toJSONString(v, SerializerFeature.PrettyFormat)))
              .as(StepVerifier::create)
              .expectNextCount(1)
              .verifyComplete();


    }