Skip to content

Latest commit

 

History

History
49 lines (31 loc) · 1.27 KB

README.md

File metadata and controls

49 lines (31 loc) · 1.27 KB

SQL Translation API

This is a Flask API that translates SQL queries from one dialect to another using the sqlglot library.

Installation

  1. Clone the repository:

    git clone https://github.com/Kayrnt/sql-translation-api.git

  2. Install the dependencies using Poetry:

    cd sql-translation-api
poetry install

  3. Start the Flask development server:

    poetry shell
flask run

    The API will be available at http://localhost:5000/translate.

Usage

To translate a SQL query, send a POST request to the /translate endpoint with a JSON body that contains the following keys:

  • sql: The SQL query to translate
  • from: The dialect of the input SQL query (e.g., mysql, postgres, sqlite)
  • to: The dialect to translate the SQL query to (e.g., mysql, postgres, sqlite)

The API will return a JSON response with the translated SQL query.

Here's an example using the curl command:

curl -X POST -H "Content-Type: application/json" -d '{"sql": "SELECT * FROM my_table", "from": "mysql", "to": "postgresql"}' http://localhost:5000/translate

This will return a JSON response with the translated SQL query.

License

This project is licensed under the MIT License. See the LICENSE file for details.