Transforming Column of Lists into Array Type in BigQuery Using REGEXP_EXTRACT and SPLIT

Converting Array-of-Strings to Array-of-Type in BigQuery: A Practical Guide to Workarounds and Solutions