Support unnest table function

1 
SELECT id, unnest.type, unnest.scores
FROM example_table, unnest(split(type, ";"), scores) as unnest(type,scores);

±-----±------±-------+
| id | type | scores |
±-----±------±-------+
| 1 | typeA | 80 |
| 1 | typeB | 85 |
| 1 | NULL | 88 |
| 2 | typeA | 87 |
| 2 | typeB | 90 |
| 2 | typeC | 95 |
±-----±------±-------+

2

@colagy

Currently this is not available. As a workaround are you creating a view with the flatten and then using the view in the FROM clause? Also which product supports this type of unnest TABLE FUNCTION?

3

Flatten() is not a table function. Trino has the unnest table function.