SQL Query for transforming array based objects in dataset in adobe experience platform

I have a dataset which has array based object called _seit.It has three sub fields:

standardint integer,

favchoice string,

se_id string

How to flatten it using sql query as part of query services.