I’m far from being an authority on DQL, but there’s pretty much nothing SQL can’t do to manipulate data sets, although some of the syntax can make your head hurt. Based on Craig’s example above, flatten looks just like you’d get from a simple join in SQL. SQL can also easily pivot rows into columns or unpivot columns into rows, maybe also applicable. You could also split strings and turn them into rows, and so on.
1 Like