v1.2.928-nightly

What's Changed

Exciting New Features ✨

• feat(copy): improve ColumnMissingError with contextual advice by @youngsofun in #20029
• feat(query): support ilike operators by @sundy-li in #20106
• feat(query): add stream backlog API and table function by @zhyass in #20104
• feat(query): support PostgreSQL aggregate syntax by @KKould in #20108
• feat: meta: add Lua transaction support by @drmingdrmer in #20131
• feat(meta): add metactl.now_ms() monotonic clock for Lua scripts by @drmingdrmer in #20136
• feat(metabench): add bulk-load and random-read benchmarks by @drmingdrmer in #20137

Thoughtful Bug Fix 🔧

• fix(query): recheck function after cast elimination by @KKould in #20102
• fix(query): avoid persisting normalized recluster stats by @zhyass in #20107
• fix(query): trigger all ready task successors by @KKould in #20120
• fix(sql): fix udaf alias handling and show function params in plans by @forsaken628 in #20061
• fix(query): set variable to NULL when subquery returns empty result by @dantengsky in #20118
• fix(query): cancel open private task runs on drop by @KKould in #20109
• fix(query): record missing spill write metrics by @dqhl76 in #20086

Code Refactor 🎉

• refactor(query): make segment compaction commit through CommitSink by @SkyFan2002 in #20114
• refactor(query): reduce parser success path overhead by @sundy-li in #20119
• refactor(functions): split aggregate tests by function by @forsaken628 in #20125
• refactor: meta: cover metactl.to_string rendering rules, add zipf by @drmingdrmer in #20133

Build/Testing/CI Infra Changes 🔌

• ci(iceberg): cover variant metadata reads by @sundy-li in #20110

Others 📒

• chore(query): add spatial join test to correctness regressions by @TCeason in #20101
• chore: Enable Virtual column features for Community Edition by @b41sh in #20116
• chore(query): Refactor SQLSmith tests into a separate library by @b41sh in #20121
• chore(query): log top-N plan node memory usage on memory limit exceeded by @dqhl76 in #20077
• chore: bump databend-meta and databend-meta-client to latest by @drmingdrmer in #20127
• chore(planner): add debug trace for optimizer statistics collection by @forsaken628 in #20010

Full Changelog: v1.2.927-nightly...v1.2.928-nightly