By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| xmlDoc |
|---|
| <Reservation><Name>Neal</Name><Flight>12</Flight><Flight>34</Flight><Flight>56</Flight></Reservation> |
| Passenger | (No column name) | (No column name) |
|---|---|---|
| Neal | <Flight>12</Flight> | 12 |
| Neal | <Flight>34</Flight> | 34 |
| Neal | <Flight>56</Flight> | 56 |