Insert into resource using SQL mode

Hi @flyinghedgehogs Thanks for reaching out! We are tracking a feature request for this use case internally. I'll post back here when we're able to ship a feature for dynamic sql table names in GUI mode.

In the meantime, my best recommendation is to make a GUI mode query for each table and call the queries dynamically based on the user input.

Working with SQL mode in this way can be fairly tricky, as articulated in this community post For example, I was able to get this hacky code working, with prepared statements disabled.