<story><title>Transpile Any SQL to PostgreSQL Dialect</title><url>https://gitlab.com/dalibo/transqlate</url></story><parent_chain></parent_chain><comment><author>jakozaur</author><text>I see a lot of these types of tools, each with some essential support, but usually they don&amp;#x27;t work. I would appreciate what is support what is not.&lt;p&gt;Tried this tool:
go run gitlab.com&amp;#x2F;dalibo&amp;#x2F;transqlate@v0.1-beta.2&lt;p&gt;select TRUNC(SYSDATE, &amp;#x27;month&amp;#x27;)  from dual&lt;p&gt;-- TRANSLATION ERROR at +1:8: unsupported date format: &amp;quot;month&amp;quot; rule=&amp;quot;replace trunc() by date_trunc()&amp;quot;
select DATE_TRUNC(&amp;#x27;month&amp;#x27;, LOCALTIMESTAMP)exit status 1&lt;p&gt;Also, at least, it would set the latest git tag, currently command from Readme.md doesn&amp;#x27;t work:&lt;p&gt;go run gitlab.com&amp;#x2F;dalibo&amp;#x2F;transqlate@latest&lt;p&gt;go: gitlab.com&amp;#x2F;dalibo&amp;#x2F;transqlate@latest: module gitlab.com&amp;#x2F;dalibo&amp;#x2F;transqlate@latest found (v0.0.0), but does not contain package gitlab.com&amp;#x2F;dalibo&amp;#x2F;transqlate&lt;p&gt;latest should point to v0.1-beta.2</text></comment>
<story><title>Transpile Any SQL to PostgreSQL Dialect</title><url>https://gitlab.com/dalibo/transqlate</url></story><parent_chain></parent_chain><comment><author>souenzzo</author><text>&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.jooq.org&amp;#x2F;translate&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.jooq.org&amp;#x2F;translate&amp;#x2F;&lt;/a&gt;&lt;p&gt;JOOQ also do that, but it is in JAVA.</text></comment>