Build(deps): Bump sqlglot from 19.6.0 to 19.7.0
Bumps sqlglot from 19.6.0 to 19.7.0.
Changelog
Sourced from sqlglot's changelog.
[v19.7.0] - 2023-11-28
💥 BREAKING CHANGES
due to
8cd7d1c
- use more canonical cast instead of to_date (commit by@tobymao
):use more canonical cast instead of to_date
due to
c413b7f
- expand positional args in order by as aliases (PR #2599 by@tobymao
):expand positional args in order by as aliases (#2599)
due to
13817f1
- avoid unnecessary copying in normalization (PR #2602 by@tobymao
):avoid unnecessary copying in normalization (#2602)
✨ New Features
739c3c7
- insert returning builder closes #2579 (commit by@tobymao
)6e3c7c1
- tsql: default database .. closes #2594 (commit by@tobymao
)
🐛 Bug Fixes
8cd7d1c
- use more canonical cast instead of to_date (commit by@tobymao
)08d60b6
- tsql: add special chars in single var tokens (PR #2582 by@georgesittas
)
↘ fixes issue #2581 opened by@Hal-H2Apps
bf29a9b
- handle ending spaces after keywords closes #2585 (commit by@tobymao
)f53f656
- optimizer: respect EXCEPT when expanding star for PIVOTs (PR #2589 by@georgesittas
)426075f
- duckdb: unqualify columns under Pivot (PR #2590 by@georgesittas
)4774431
- tsql: generate DATEPART when the format is quarter (PR #2591 by@georgesittas
)
↘ fixes issue #2586 opened by@abadugu13
dc783a8
- bigquery: generate FORMAT_DATE for TimeToStr (PR #2596 by@georgesittas
)2ecfd34
- time format chunk misses from mapping, but its constituent parts are not (PR #2598 by@georgesittas
)
↘ fixes issue #2597 opened by@j-bennet
c413b7f
- expand positional args in order by as aliases (PR #2599 by@tobymao
)c66e413
- oracle: to_char nlsparam closes #2601 (commit by@tobymao
)
♻ Refactors
Commits
-
13817f1
refactor!: avoid unnecessary copying in normalization (#2602) -
c66e413
fix(oracle): to_char nlsparam closes #2601 -
c413b7f
fix!: expand positional args in order by as aliases (#2599) -
2ecfd34
Fix: time format chunk misses from mapping, but its constituent parts are not... -
dc783a8
Fix(bigquery): generate FORMAT_DATE for TimeToStr (#2596) -
9bef03a
Fix!(hive): truncate division result in _date_diff_sql (#2595) -
eb15a5f
Fix!(redshift): leave DATEADD and DATEDIFF as-is when generating them (#2588) -
6e3c7c1
feat(tsql): default database .. closes #2594 -
4774431
Fix(tsql): generate DATEPART when the format is quarter (#2591) -
426075f
Fix(duckdb): unqualify columns under Pivot (#2590) - Additional commits viewable in compare view