function selectFieldsFromRepeatedRecord()

in includes/sql.js [73:92]


function selectFieldsFromRepeatedRecord(fieldName, columns, safe_cast_columns) {
    let result = "";
    const tmpAlias = `${fieldName}ta`;
    const doubleSpace = "  "
    columns.forEach(column => {
        if(result.length > 0) {
            result = result + ',\n';
        }
        result = result + `${doubleSpace}${doubleSpace}`;
        if(column in safe_cast_columns) {
            result = result + 'SAFE_CAST(';
        }
        result = result + `${tmpAlias}.${column}`;
        if(column in safe_cast_columns) {
            result = result + ` AS ${safe_cast_columns[column]})`;
        }
        result = result + ` AS ${column}`;
    })
    return 'ARRAY( SELECT STRUCT (\n' + result + `\n${doubleSpace}) FROM UNNEST(${fieldName}) AS ${tmpAlias} ) AS ${fieldName}`;
}