generate_sql API endpoint

[kalyan-myautoiq]

Hi,
Currently when I invoke the http://localhost:3001/api/v1/generate_sql endpoint from postman, I get the generated SQL in the response.

For the same question, in the UI there is an option to view the original query which can be executed in mysql workbench and it works.

Is there a way to tell the API to optionally return the original sql? The reason is, I would like to make use of a sql execution tool given a valid SQL. Currently, the SQL generated by the API endpoint is not friendly with mysql with the double quotes and aliases.

[kalyan-myautoiq]

In the documentation

Use the returnSqlDialect: true parameter to get SQL in your database's native dialect and run it directly in your database

I put his flag in the generate_sql endpoint and it returned the mysql version correctly.