RISE

RISERISE is an automated rule-driven SQL dialect translation tool that utilizes dialect-aware query reduction.RISE consists of the following five parts：adaptiveparser.py: Parse the SQL queries into the corresponding abstract syntax trees.queryreduction.py: Apply dialect-aware query reduction to the source SQL queries.llmtranslator.py: Translate the simplified queries with specific dialect directly using LLMs.rulegen.py: Extract the translation rules between the queries before and after translation.applyrule.py: Apply the rules to directly translate the corresponding dialects in the source SQL queries.EvaluationTPC-DS: 99 queries from <i>PostgreSQL</i> to <i>MySQL</i>.SQLProBench: 44 queries from <i>PostgreSQL</i> to <i>Oracle</i>.<br>