@Override
    public NativeQuerySpec<Record> select(String sql, Object... args) {
        return new NativeQuerySpecImpl<>(this, sql, args, DefaultRecord::new, false);
    }
@Test
    public void testInner() {
        DefaultQueryHelper helper = new DefaultQueryHelper(database);

        database.dml()
                .insert("s_test")
                .value("id", "inner-test")
                .value("name", "inner")
                .value("testName", "inner")
                .value("age", 31)
                .execute()
                .sync();


        helper.select("select age,count(1) c from ( select *,'1' as x from s_test ) a group by age ", 0)
              .where(dsl -> dsl
                  .is("x", "1")
                  .is("name", "inner")
                  .is("a.testName", "inner")
                  .is("age", 31))
              .fetchPaged(0, 10)
              .doOnNext(v -> System.out.println(JSON.toJSONString(v, SerializerFeature.PrettyFormat)))
              .as(StepVerifier::create)
              .expectNextCount(1)
              .verifyComplete();
    }