On 05/08/2018 09:19 AM, Chapman Flack wrote: > > While PostgreSQL certainly has extensions to and divergences from > standard SQL syntax, some historical and some recent, it seems like > there ought to be a highish bar for adding new ones; or, looking at it > another way, has this feature been proposed to the SQL committee? > It doesn't sound like a bad idea, and supporting new syntax for it > would be an easier call it if it were known to be in an SQL draft > somewhere.
There seems to have been some work at Databricks adding higher-order function syntax to their SQL; they've chosen the name 'transform' for 'map', and also provided 'exists', 'filter', and 'aggregate'. https://databricks.com/blog/2017/05/24/working-with-nested-data-using-higher-order-functions-in-sql-on-databricks.html -Chap