bq: unnest array vs. union select

bq.sql

# TODO(db): Figure out if either of these is better than the other
# - Both give "query resources exceeded" on what_is_junk with all of the homes/addresses fields

def template_unnest_array(table, fields):
    df = bq.Query(with_od_homes('''
        select * from unnest([
            %(array_elems)s
        ])
        order by i
    ''' % dict(
        array_elems=',\n'.join([
            '''
                struct(
                    %(i)s as i,
                    ...
                )
            ''' % dict(
                i=i,
                ...
            )
            for i, ... in enumerate(...)
        ]),
    ))).to_dataframe()
    df = df.drop('i', axis=1)
    return df

def template_union_select(table, fields):
    df = bq.Query(with_od_homes('''
        %(selects)s
        order by i
    ''' % dict(
        selects='\nunion all\n'.join([
            '''
                select
                    %(i)s as i,
                    ...
                from %(table)s
            ''' % dict(
                i=i,
                ...
            )
            for i, ... in enumerate(...)
        ])
    ))).to_dataframe()
    df = df.drop('i', axis=1)
    return df