Is there a way to select nested records into a table?
I have a table, T, in Bigquery which contains simple fields and one nested field.
I would like to effectively “select * from T where …” and store the result in a new table U.
I want U to have the same schema as T (including the nested field).
Is there a way to do this within Bigquery or is the solution to export/transform/import?