Create SQL Insert Statement from a form input

Queries and Resources
1

Hi There,

Is it possible to use the form.data instead of having to define every single value and column on a SQL insert statement?

This is what is currently working.

image
image1278×656 104 KB

I would like to do but haven't managed:

Update INTO comm_prop ( {{Object.keys(formNuevoItem.data)}} )
values (
{{Object.values(formNuevoItem.data)}}
)

Is this possible at all?

Thanks,
David

2

Use the GUI mode instead of SQL mode selector and yes this can be done.

2 Likes
3

@ScottR I cannot use the GUI as it fails when I try to do an insert. It could be due to the database being cockroachDB.

Any suggestions how to destructure an object so we can pass values into the SQL? I couldn't find anything on the

Here is a test example. Where I want to create the id from an array.

image

image
image1005×676 60.4 KB

4

Here is what happens when I try using the GUI mode

image
image971×583 35.5 KB

5

I have worked it out. Instead of trying to run the INSERT statement for all rows at the same time what needs to happen is you need to call the INSERT (query) from a JS Query and pass each row to the INSERT which will then run the SQL script.

This is because there is some SQL Injection protection enabled in Retool and you don't want to disable it. This means you cannot add variables columns and values to the SQL.

Here is a good explanation on how to trigger the query and pass the row to the INSERT Query

2 Likes