SQL Translate

Requirements

Agent: builder or migrator (may write translated SQL to files) Tools used: sql_translate, read, write, altimate_core_validate

Translate SQL queries from one database dialect to another using sqlglot's transpilation engine.

Workflow

1. Determine source and target dialects — If the user did not specify both dialects, ask which source and target dialects to use. Common dialects: snowflake, bigquery, postgres, mysql, tsql, hive, spark, databricks, redshift, duckdb.

2. Get the SQL to translate — Either:

   • Read from a file path provided by the user (use read)
   • Accept inline SQL from the user's message
   • Read from clipboard or stdin if mentioned