I need the diff on this vs Snowflake/Bigquery/Reds...
# data-news
t
I need the diff on this vs Snowflake/Bigquery/Redshift implementations http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
a
The ANSI SQL specs are notoriously disconnected from what platforms have actually implemented. Initially, I think these standards were meant to guide implementations - but nowadays it feels like they are consistently trying to catch up with each vendor blazing ahead to deliver what is/was needed.
If I had to give a random guess, I'd say each of the three platforms you metion have something between 30-60% adherence. But to answer with confidence, I'd have to google each one, per header point.