SQL generation and modification

SQL Generation

After filling in relevant questions within the context, in this case, healthcare, you can press the 'Generate' button to proceed. After generating questions, the system will automatically generate SQL, which will then appear in the SQL column.

As a result, we have the following SQL query:

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Bandung'

SQL Modification

After filling in relevant questions within the context, proceed by pressing the 'Execute' button. Following the generation of questions, the system will automatically generate SQL. However, if we wish to modify the SQL query, simply click the SQL section and then make the necessary changes to the SQL query.

We can modify the generated SQL query from the previous questions by clicking on the SQL section. Afterward, we can edit the SQL according to our specific needs.

You can try modifying the existing SQL query in the box according to your needs. For example, you can change the location you want to retrieve by replacing 'Bandung' with 'Semarang'.

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Bandung'

We can modify the query to retrieve data from the location 'Semarang' look like this.

SELECT * FROM "stagging-qore-data-potato-712352".test
WHERE lokasi = 'Semarang'