Hi, is there a way to create sql without db conection or wrapping in transaction. I just want to create string sql query using exposed DSL

Sql is inherently dialect specific but for basic cases maybe this works:

query.prepareSQL(QueryBuilder(false))

This requires Db connection and transaction

The easiest workaround is probably to connect to an inmemory h2 database then

yeah but it felt too hacky 😄

This requires a connection because a metadata required to build a query can only be retrieved from the server.