Hi, is there a way to create sql without db conection or wrapping in transaction. I just want to cre...

# exposed

[Berkay Özkan]

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

[spand]

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

query.prepareSQL(QueryBuilder(false))

[Berkay Özkan]

This requires Db connection and transaction

[spand]

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

[Berkay Özkan]

yeah but it felt too hacky 😄

[Aleksei Tirman [JB]]

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