Invalid EXECUTE IMMEDIATE sql string error when fully qualified target table name is used in bqml_generate_text

[vitalii-filipov]

Hello Everyone,

When bqml_generate_text stored procedure is called with target_table parameter set to a fully qualified table name with a project that contains dashes -, this error is shown (added formatting for readability)

Invalid EXECUTE IMMEDIATE sql string `
    CREATE TEMP TABLE _SESSION.text_batch AS 
    (SELECT * 
           FROM (SELECT description_id, '''
            My prompt with descriptions:
           ''' || descriptions || '''
           Your answer as a JSON:
           ''' AS prompt FROM `project-with-dashes.some_dataset.source_table` WHERE TRUE) AS S 
          WHERE NOT EXISTS (SELECT * FROM project-with-dashes.some_dataset.target_table AS T WHERE S.description_id = T.description_id)
          LIMIT 1000
    )
 `, Syntax error: Missing whitespace between literal and alias at [bqutil.procedure_eu.bqml_generate_text:123:5] 

Code that produces the error:

CALL `bqutil.procedure.bqml_generate_text`(
    "project-with-dashes.some_dataset.source_table",   -- source table
    "project-with-dashes.some_dataset.target_table",  -- destination table
    "project-with-dashes.some_dataset.text_generation_model",        -- model
    """
    ''' My prompt with descriptions: ''' || descriptions || ''' Your answer as a JSON: '''
    """,                                     -- content column
    ["description_id"],              -- key columns
    '''{
        "temperature": 0
    }'''                                        -- optional arguments
);