Using AI assistant to construct SQL queries
Find out here how to enable/disable the AI assistant feature.
Switch the page to the edit mode
Insert the Table Transformer macro and paste the table/s or the macros outputting tables within the macro body
Select the macro and click Edit
Select ChatGPT assistant tab
Ask the assistant to write the SQL query according to your needs
Check the result via the Preview window
- Modify the SQL query if needed
- Save the macro