Feature Request - var interpolation inside of query()

[markhuge]

When creating a template, it'd be really handy to be able to pass in a relevant string that varies between tasks vs having to pass the entire query into the var

var thingName string
var crit lambda

batch
    |query('''
       SELECT mean("value")
       FROM "myDB"."autogen".foo
       WHERE "thing" = {{ thingName }}
    ''')
    ...
   |alert()
     .crit(crit)
   ...

[rossmcdonald]

@markhuge I believe you should be able to do this already with string concatenation:

var thingName string
var crit lambda

batch
   |query('SELECT mean("value") FROM "myDB"."autogen".foo WHERE "thing" = ' + thingName)
    ...
   |alert()
     .crit(crit)
   ...

But I agree that being able to use templated variable names would be the best solution.

[markhuge]

@rossmcdonald Just FYI, the string concatenation does expand the variable, but it's not evaluated by the query. It looks like it needs to be wrapped in escaped single quotes to work:

|query('SELECT mean("value") FROM "myDB"."autogen".foo WHERE "thing" = \'' + thingName + '\'')

[rossmcdonald]

Ah, yes, you will also need to include quotes around any literals. Thanks for letting me know.