sql.translate is a docker tools for translate sql from one to another, it's a docker wrapper for the org.jooq.
You can see more details usage in Jooq.
- Convert To mysql
docker run obpt123/sql-translate -T mysql -s "select top 1 name, newid() as randomId from [dbo].[table1]"
the result for the mysql will be:
select name, uuid() as randomid from `dbo`.`table1` limit 1;- Convert to postgres
docker run obpt123/sql-translate -T postgres -s "select top 1 name, newid() as randomId from [dbo].[table1]"
the result for the postgres will be:
select name, gen_random_uuid() as randomid from "dbo"."table1" fetch next 1 rows only;