Dynamic SQL Connector

Support & Troubleshooting
#1

Hey everyone,

I’m trying to build a SQL function that is dynamic. Here’s a walkthrough of what I’d ideally have it look like…

Inputs:

  1. Column_Name
  2. Some_Value
  3. ID

Query:

UPDATE Table 
SET $Column_Name$ = $Some_Value$
WHERE ID = $ID$

Has anyone successfully done this before?
I know creating multiple connector functions would be a workaround, but I’d ideally like to make column names dynamic.

Thanks!