I need to create some SQL statements at execution time, not compilation, and have therefore turned to a BQ UDF in JS.
It took me some time to figure that Dataform engine is confusing interpolation used within my UDF with "it's own".
For example,
create temp function test(x string) returns string language js as r"return `seems ${x} to me`"; select test('ok')
Instead of reverting to verbose string concatenations - even if my AI friend can help me-, any idea/trick to go around this, e.g. using a special notation ? If not, could be a feature request.