dialect specific SQL generation with jooq

CodegenApplicationTests.kt

package geowarin.codegen

import org.amshove.kluent.shouldEqualTo
import org.jooq.SQLDialect
import org.jooq.impl.DSL
import org.jooq.impl.DefaultConfiguration
import org.junit.Test

class CodegenApplicationTests {

  @Test
  fun `should generate sql`() {

    val originalQuery = "SELECT * FROM (VALUES (1, 'a'), (2, 'b')) t(a, b)"

    generateSql(SQLDialect.H2, originalQuery) shouldEqualTo
        """
          select
            t.a,
            t.b
          from (
            (
              select
                null a,
                null b
              where 1 = 0
            )
            union all (
              select *
              from (values
                (1, 'a'),
                (2, 'b')
              ) t
            )
          ) t
""".trimIndent()
  }

  private fun generateSql(sqlDialect: SQLDialect, sql: String): String {

    return DSL.using(DefaultConfiguration().set(sqlDialect))
        .parser()
        .parseQuery(sql).toString()
  }

}