Build(deps): Bump sqlglot from 20.5.0 to 20.8.0
Bumps sqlglot from 20.5.0 to 20.8.0.
Changelog
Sourced from sqlglot's changelog.
[v20.8.0] - 2024-01-08
💥 BREAKING CHANGES
✨ New Features
2d822f3
- improve support for Doris' TO_DATE, Oracle's SYSDATE (PR #2775 by@georgesittas
)7187215
- desc builder (commit by@tobymao
)ba62639
- add support for CREATE FUNCTION (SQL) characteristics for MySQL and Databricks (PR #2777 by@viethungle-vt1401
)
↘ addresses issue #1980 opened by@xinglin-zhao
963e2dc
- snowflake: add support for SHOW COLUMNS (PR #2778 by@andrew-sha
)46c9733
- tsql: round func closes #2790 (commit by@tobymao
)2dfb7e8
- optimizer: add support for the UNPIVOT operator (PR #2771 by@georgesittas
)
🐛 Bug Fixes
68e1214
- column field typing (commit by@tobymao
)3f31706
- tsql exec command #2772 (commit by@tobymao
)f6cbadb
- snowflake: add a couple of special fn types (PR #2774 by@georgesittas
)0634f73
- optimizer: replace star with outer column list (PR #2776 by@georgesittas
)d31ae0d
- allow string aliases closes #2788 (commit by@tobymao
)8f8f00e
- don't transform null ordering with positional orders closes #2779 (commit by@tobymao
)f85ce3b
- tsql: gracefully handle complex formats in FORMAT (PR #2794 by@georgesittas
)a2499f5
- tsql: generate correct TRIM syntax closes #2786 (commit by@georgesittas
)59ecd2f
- clickhouse: allow transpilation of countIf, fix 2 arg variant parsing (PR #2795 by@georgesittas
)3f7748b
- don't transpile nulls last in window specs (commit by@tobymao
)[v20.7.1] - 2024-01-04
🐛 Bug Fixes[v20.6.0] - 2024-01-04
💥 BREAKING CHANGES
due to
4648c6a
- set sample clause keyword(s) as class constant to enable transpilation (PR #2750 by@georgesittas
):set sample clause keyword(s) as class constant to enable transpilation (#2750)
due to
0b6bdc4
- improve transpilation of JSON value extraction (PR #2744 by@georgesittas
):improve transpilation of JSON value extraction (#2744)
due to
862b305
- improve table sampling transpilation (PR #2761 by@georgesittas
):improve table sampling transpilation (#2761)
... (truncated)
Commits
-
2dfb7e8
Feat(optimizer): add support for the UNPIVOT operator (#2771) -
ad2a809
Fix!(tsql): use square bracket quotes by default, not quotes (#2796) -
3f7748b
fix: don't transpile nulls last in window specs -
59ecd2f
Fix(clickhouse): allow transpilation of countIf, fix 2 arg variant parsing (#... -
a2499f5
Fix(tsql): generate correct TRIM syntax closes #2786 -
f85ce3b
Fix(tsql): gracefully handle complex formats in FORMAT (#2794) -
46c9733
feat(tsql): round func closes #2790 -
8f8f00e
fix: don't transform null ordering with positional orders closes #2779 -
d31ae0d
fix: allow string aliases closes #2788 -
963e2dc
Feat(snowflake): add support for SHOW COLUMNS (#2778) - Additional commits viewable in compare view