v0.4.0

Changed (internal refactor)

• maxcompute.py renamed to dialect.py — the coordinator class MaxCompute is now in src/sqlglot_maxcompute/dialect.py
• MaxComputeParser now inherits from HiveParser (imported from sqlglot.parsers.hive) instead of Hive.Parser
• MaxComputeGenerator now inherits from HiveGenerator (imported from sqlglot.generators.hive) instead of Hive.Generator
• sqlglot dependency floor raised to >=30.1.0 (first release with split parsers/ and generators/ modules)

Fixed (parser + generator correctness)

• TRUNC(n, d) now maps to exp.Trunc for numeric truncation; TRUNC(dt, 'unit') still routes to date truncation
• BOOL_AND(col) / BOOL_OR(col) now emit correct MaxCompute names instead of LOGICAL_AND / LOGICAL_OR
• LOCATE(sub, str, start) now passes the start position through to INSTR(str, sub, start) instead of silently dropping it

v0.3.1

Fixed (parser correctness)

• NOW() now maps to exp.CurrentTimestamp so cross-dialect output is CURRENT_TIMESTAMP instead of CURRENT_DATETIME() (BigQuery-specific); round-trip in MaxCompute produces GETDATE() (a synonym)
• DATE_SUB(date, n) now maps to exp.DateSub so output is DATEADD(date, -n, 'DAY') instead of DATEADD(date, n * -1, 'DAY')

v0.3.0

Fixed (generator correctness)

• TO_DATE(str, fmt) now models return type as DATETIME (exp.StrToTime); TO_DATE(str) remains DATE (exp.TsOrDsToDate) — cross-dialect consumers now see the correct type for each form
• SPACE(n) now emits SPACE(n) instead of REPEAT(' ', n)
• VAR_POP(x) now emits VAR_POP(x) instead of VARIANCE_POP(x)
• VAR_SAMP(x) / VARIANCE(x) now emits VAR_SAMP(x) instead of VARIANCE(x)
• INSTR(s, sub) now emits INSTR(s, sub) instead of LOCATE(sub, s)
• SUBSTR(s, pos, len) now emits SUBSTR instead of SUBSTRING

Added (parser)

• SUBSTR as explicit MaxCompute parser alias for exp.Substring

Changed (internal)

• Dialect split: maxcompute.py now delegates to parser.py and generator.py (mirrors sqlglot's own mypyc-compile refactor)

Tests

• Regression coverage for ~20 functions previously relying on untested Hive inheritance:
  INITCAP, REVERSE, REPEAT, LPAD/RPAD, LTRIM/RTRIM, REGEXP_REPLACE,
  REGEXP_EXTRACT_ALL, INSTR, FIND_IN_SET, SUBSTR, SUBSTRING_INDEX,
  CONCAT_WS, FORMAT_NUMBER, COLLECT_LIST/SET, VAR_SAMP, VAR_POP,
  PERCENTILE, STDDEV, GREATEST/LEAST, CBRT, FACTORIAL, GET_JSON_OBJECT,
  JSON_TUPLE

v0.2.0

Added

Generator (MaxCompute SQL output)

• DATEADD / DATEADD with negated delta for DateSub (e.g. BigQuery DATE_SUB → DATEADD(dt, -3, 'DAY'))
• DATEDIFF with optional unit argument
• DATETRUNC / TRUNC_TIME with full week-unit support ('week' → 'week(monday)')
• DATEPART via named extract_sql method
• GETDATE() for CurrentTimestamp, NOW() for CurrentDatetime
• TOLOWER / TOUPPER for Lower / Upper
• FROM_JSON for ParseJSON, GET_USER_ID() for CurrentUser, TO_MILLIS for UnixMillis
• APPROX_DISTINCT, ARG_MAX, ARG_MIN
• WM_CONCAT(sep, col) via named groupconcat_sql method (with default separator guard)
• TO_CHAR via named tochar_sql method
• Type mapping: VARCHAR / CHAR / TEXT → STRING; DATETIME preserved

Parser (read direction)

• Statistical aggregates: STDDEV_SAMP, COVAR_POP, COVAR_SAMP, CORR, MEDIAN, PERCENTILE_APPROX, BITWISE_AND_AGG, BITWISE_OR_AGG, BITWISE_XOR_AGG
• MAX_BY / MIN_BY as aliases for ARG_MAX / ARG_MIN

Fixed

• TO_DATE format string preserved as-is (Hive was converting Oracle-style mm → %M)
• WEEKDAY round-trips as WEEKDAY(dt) in MaxCompute output (other dialects still get the (DAYOFWEEK + 5) % 7 arithmetic)
• DATETRUNC week-unit emits valid 'week(monday)' string literal instead of bare WEEK(MONDAY)
• groupconcat_sql defaults separator to ',' when absent (prevents invalid WM_CONCAT(col))
• Python >=3.9 compatibility (removed ipykernel, relaxed pytest floor)
• Added sqlglot<31 upper bound to prevent unexpected breakage on major releases

Infrastructure

• GitHub Actions CI across Python 3.9 / 3.10 / 3.11 / 3.12
• README with usage examples and function coverage table

v0.1.0

Initial release.

• MaxCompute dialect registered via Python entry points
• Parser: ~40 date/time, string, array, and map functions
• DDL: LIFECYCLE, RANGE CLUSTERED BY, AUTO PARTITIONED BY