 |
| Modern SQL in PostgreSQL (slideshare.net) | ||
| recommended by 1 user | 2015 | 446 points by lelf | databases | original thread | | ||
| One user recommended this thread. What they said: |
| greggyb Nov 7, 2015 | on: Opaleye’s sugar on top: SQL in the type system | context |
>I mean, have any vendors actually gone beyond SQL-92?
Yes. Here's a pretty good summary presentation (it says it's Postgres-focused, but it provides adoption data for the major vendors)[0] and the HN comments[1].
What we tend to see (I speak from a position as a BI consultant - I get to see lots of companies' database infrastructure) is that adoption of new SQL constructs is mostly limited by the developers, and in some cases IT departments who won't upgrade SQL server software.
New SQL being limited by developers comes in two flavors, crusty DBAs and do-it-all-in-the-app-layer developers. The second type tends to be more common among demographics similar to HN.
[0] http://www.slideshare.net/MarkusWinand/modern-sql
[1] https://news.ycombinator.com/item?id=9018129