One application i'm responsible is running on a sql server database but most of the integration tests are running against a hsql in memory database. For a bigger integration test i had the need to convert some sql scripts. While researching i found this wonderful tool. Im not affiliated with them in any way. I'm writing this more as a note to myself. I want to investigate it more.

The left textfield is for your input sql and the right textfield is for your translated output.

Enjoy:

https://www.jooq.org/translate/