3 ms·
The best thing to happen in sql in recent times is snowflake starting to allow an extra comma in the end of the expression list lol. Now I can ask all the DBAs
by ramraj07 2y ago
The best thing to happen in sql in recent times is snowflake starting to allow an extra comma in the end of the expression list lol. Now I can ask all the DBAs in my life to stop formatting their queries comma first!
- willvarfar 2y agoYeap BigQuery also recently added allowing some trailing commas, although not everywhere e.g. not inside structs etc. Definitely makes things much easier. There are lots of relaxations they could make that would help tooling and templated stuff, e.g. allowing FROM before SELECT and allowing multiple WHEREs and allowing comparision/hashing of structs and arrays and things. About the only rss feed I ever see is the BigQuery announce one; they actually make interesting incremental improvements all the time, e.g. recently added a RANGE type and functions (although it works for dates and timestamps, but not integers; argh, so close...)
- zX41ZdbW 2y agoNot only Snowflake: https://play.clickhouse.com/play?user=play#U0VMRUNUIAogIDEsCiAgJ0hlbGxvJywKRlJPTSBzeXN0ZW0ub25lCg== https://play.clickhouse.com/play?user=play#U0VMRUNUIAogIDEsC...