在 Snowflake dwh 中是否可以檢索 SQL 查詢結果并將其作為變量傳遞給同一過程中的下一個查詢？我正在嘗試嘗試 %ROWCOUNT, CURSOR case 并陷入以下困境：創建或替換過程 PASS_VAR_IN_JS()返回 VARCHAR語言 javascript  作為    $$    var command = "SELECT * FROM TABLE WHERE ATTRIBUTE = 'Value'";    var stmt = snowflake.createStatement( {sqlText: command} );    var result1 = stmt.execute();    返回結果1.getColumnName(3); //這會返回列名    var col_name = result1.getColumnName(3); //將列名保存到變量中    //將列名傳遞給查詢    var stmt = snowflake.createStatement({sqlText: "SELECT * FROM INFORMATION_SCHEMA WHERE COLUMN_NAME = ;", binds:[col_name]});    $$; UPDATE - working code that passes one result to another query<pre>CREATE OR REPLACE PROCEDURE szpotma_rowcount()RETURNS VARCHAR(250)LANGUAGE JAVASCRIPTas$$  var command = `SELECT ATTR1 FROM TABLE1 LIMIT 1`;   var stmt = snowflake.createStatement( {sqlText: command} );  var rs = stmt.execute(), col_name ;  if (rs.next()) {    col_name = rs.getColumnValue(1);    stmt = snowflake.createStatement({        sqlText: `SELECT STATUS FROM TABLE_STATUS WHERE ATTR1 = :1`, binds: [col_name]});    //view second query results    rs = stmt.execute();        rs.next()    return rs.getColumnValue(1);  }$$