One of the best features of AI is that it understands natural language really well. Combined with the context provided by the integrated chat, it's easy to describe what you want from a query and have the AI write the SQL for you. It's fast, it's easy, it saves time.
Here's an example on the Mantis bug tracker database.
| 1. | describe what you want in a query, be as precise as possible, although changes can be added later |
| 2. | click Send Message and wait for the results |
| 3. | after a short while, the AI returns the query and you can use the buttons to pass is to an SQL Editor |
| 4. | execute the query! |
Refine your queries
If you're not happy with the result, you can add additional filters, joins and so on, and let the AI Assistant modify the query.
Here's an example follow up question. The AI Assistant understands the context of the question and keeps the current project name as requested before.
The possibilities are endless and query writing is easier than ever.