Build(deps): Bump sqlglot from 20.8.0 to 20.9.0

Bumps sqlglot from 20.8.0 to 20.9.0.

Changelog

Sourced from sqlglot's changelog.

[v20.9.0] - 2024-01-18

💥 BREAKING CHANGES

• due to 1be93e4 - properly support all unix time scales (commit by @​tobymao):

  properly support all unix time scales

✨ New Features

• 816976f - extend submodule annotate_types to handle STRUCT (PR #2783 by @​fool1280)
• 7bce2f6 - oracle: add support for ORDER SIBLINGS BY clause (PR #2821 by @​georgesittas)
  • ↘ addresses issue #2819 opened by @​Shweta-BI-Lead
• ce8d254 - snowflake: parse RM/REMOVE as commands (PR #2825 by @​georgesittas)
  • ↘ addresses issue #2824 opened by @​sfc-gh-jlambert
• 1902778 - add support for multi-unit intervals (PR #2822 by @​georgesittas)
  • ↘ addresses issue #2793 opened by @​nikmalviya
• a537898 - add support for DESCRIBE EXTENDED (PR #2828 by @​georgesittas)
• 6e50759 - clickhouse: support Date32 type (PR #2830 by @​pkit)
• 9560e8f - add support for Heredocs in Databricks Python UDFs (PR #2801 by @​viethungle-vt1401)
• 52ed590 - transpile SELECT .. INTO to dialects that do not support it (PR #2820 by @​giorgosnikolaou)
• ea536c4 - remove target alias in trino merge (PR #2852 by @​eakmanrq)

🐛 Bug Fixes

• 6ddbefc - snowflake: apply range parser after colon, if any (PR #2800 by @​georgesittas)
  • ↘ fixes issue #2798 opened by @​mbarugelCA
• 0c4f44e - oracle: regexp_replace replacement is optional closes #2803 (commit by @​tobymao)
• 5072d5a - oracle: improve parsing of JSON_OBJECT[AGG] functions (PR #2807 by @​georgesittas)
  • ↘ fixes issue #2806 opened by @​Shweta-BI-Lead
• ea39f10 - optimizer: pushdown predicates more conservatively to avoid DAG cycles (PR #2808 by @​georgesittas)
  • ↘ fixes issue #2797 opened by @​Konntroll
• ea58003 - snowflake: insert overwrite into closes #2815 (commit by @​tobymao)
• d5fa5be - optimizer: handle table alias columns for (UN)PIVOTs (PR #2816 by @​georgesittas)
  • ↘ fixes issue #2791 opened by @​billstark
• 24177f3 - unnest star expansion closes #2811 (PR #2818 by @​tobymao)
• 3dba6c1 - add parentheses to no_safe_divide args (PR #2826 by @​j1ah0ng)
• ed68d6b - clickhouse: add ipv4/6 data type parser (PR #2829 by @​pkit)
• 70b280f - allow insert columns to have spaces (commit by @​tobymao)
• 57917b8 - oracle: TO_TIMESTAMP not parsed as StrToTime (PR #2833 by @​pkit)
  • ↘ fixes issue #2831 opened by @​Rhiyo
• 9960e11 - optimizer: annotate struct value without alias correctly (PR #2812 by @​fool1280)
• a6d396b - doris: add transformation of aggregation function and last_day function (PR #2835 by @​echo-hhj)
• 8cc252b - interval without unit alias closes #2838 (commit by @​tobymao)
• 607817f - schema with period name closes #2842 (commit by @​tobymao)
• 1be93e4 - properly support all unix time scales (commit by @​tobymao)
• a657fc0 - clickhouse,doris: fix the transformation of ArraySum (PR #2843 by @​echo-hhj)
• c92888c - parser: fix order of query modifier parsing for nested subqueries (PR #2851 by @​georgesittas)
• 7949a4f - clickhouse: ensure arraySum generation is preserved, add tests (commit by @​georgesittas)
• 17a6ac6 - move comment in expr as alias next to the alias (PR #2853 by @​georgesittas)

♻ Refactors

• 9e5ae50 - use flag instead of regex (commit by @​tobymao)

... (truncated)

Commits

• 5c13a1e Refactor: simplify merge without target transformation (#2854)
• 17a6ac6 Fix: move comment in expr as alias next to the alias (#2853)
• ea536c4 feat: remove target alias in trino merge (#2852)
• 7949a4f Fix(clickhouse): ensure arraySum generation is preserved, add tests
• c92888c Fix(parser): fix order of query modifier parsing for nested subqueries (#2851)
• a657fc0 Fix(clickhouse,doris): fix the transformation of ArraySum (#2843)
• 1be93e4 fix!: properly support all unix time scales
• f040262 Revert "Fix formatting (#2848)"
• 90e67fb Fix formatting (#2848)
• 607817f fix: schema with period name closes #2842
• Additional commits viewable in compare view