Big Query Extracting date from string

| orders |

|sold [2022-06-09 to 2022-06-17] |

What I am trying to get is

select
    Orders, REGEXP_EXTRACT_ALL(Orders,r'([0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9])') dates
from table

But BQ gives me the result in one row then split into 2 rows

when exported to csv it is

I have tried to select left/right to get the fields I want but get an array error from Big Query

Pointers Appreciated

>Solution :

Use below approach

select Orders, dates[offset(0)] as date1, dates[offset(1)] as date2
from table, 
UNNEST([struct(REGEXP_EXTRACT_ALL(Orders,r'([0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9])') as dates)])    

if applied to sample data in your question – output is