News for hackers. Stuff that matters.
Re:PartiQL: One query language for all your data by dlurton on Thursday August 01, 2019 @05:05PM (#20588364)
One big difference is native support for nested data that's built right into the syntax of the language. Most other SQL implementations allow support for nested data through functions which have non-intuitive syntax.
Re:PartiQL: One query language for all your data by cmollis on Thursday August 01, 2019 @06:21PM (#20588919)
We generally build views to unnest the arrays, maps, and structs and query from them (or build other tables from the views in hive) but something like this is certainly a bit easier