This is a tool that translates SQL dialect among various databases.
An online live demo is available to illustrate the feature of this tool. http://107.170.101.241:8080/sqlfrog/
Document: https://github.com/sqlparser/sqlfrog/wiki
- Read and parse input SQL query, turn SQL text into a parse tree.
- Scan the generated parse tree nodes to find out SQL syntax that need to be converted from the source database to the target database.
- Modify the parse tree nodes to meet the syntax requirement of the target database.
- Rebuild the SQL query from the parse tree for the target database.