release: v0.81.0 required reviews

All PRs and unassociated commits:

[ ] #23879 [persist] Finalize method in the CLI (@bkirwi)
[ ] #23949 sql: store ServerVar default as Owned instead of &'static (@danhhz)
[ ] #23943 adapter: log redacted SQL if stuck on execute command (@benesch)
[ ] #23842 catalog: Move builtin types to correct schema (@jkosh44)
[ ] #23788 sql: RETAIN HISTORY for materialized views (@mjibson)
[ ] #23954 ci/test: fix uploading of sources to PolarSignals (@benesch)
[ ] #23953 dbt-materialize: more gracefully handle contracts on unknown types (@benesch)
[ ] #23956 adapter: RETAIN HISTORY for SOURCES (@mjibson)
[ ] #23958 doc/user: add docs for AWS connections (@benesch)
[ ] #23959 lexer: fix lexing of comments within operators (@mjibson)
[ ] #23960 sql-pretty: add wasm crate (@mjibson)
[ ] #23957 *: upgrade to AWS SDK v1+ (@benesch)
[ ] #23928 ci: check existence of docker images without pulling (@nrainer-materialize)
[ ] #23940 tests: version resolution: refactoring to reduce code duplication (@nrainer-materialize)
[ ] #23923 lint: align bin/lint with linting in CI (@nrainer-materialize)
[ ] #23966 lint: improve output (@nrainer-materialize)
[ ] #23920 tests: allow running individual testdrive test in cloudtest (@nrainer-materialize)
[ ] #23941 tests: version resolution: allow use-case specific commit overrides (@nrainer-materialize)
[ ] #23926 adapter: move dataflows from coord to optimize (@aalexandrov)
[ ] #23971 output consistency: add hex value to text type (@nrainer-materialize)
[ ] #23973 lint: fix issues in code (@nrainer-materialize)
[ ] #23981 Various SLT fixes/workarounds (@def-)
[ ] #23975 lint: fix return code handling (@nrainer-materialize)
[ ] #23976 lint: fix stderr output handling (@nrainer-materialize)
[ ] #23968 dbt-materialize: release v1.7.2 (@morsapaes)
[ ] #23982 tests: fix return code handling (@nrainer-materialize)
[ ] #23597 platform-checks: Disable KafkaChecks for backup+restore (@def-)
[ ] #23830 ci: re-introduce VersionsFromDocs, move legacy-upgrade to tests (@nrainer-materialize)
[ ] #23985 docs: fix parsing of segment data (@sjwiesman)
[ ] #23898 [persist/expr] Use could_error function property in the interpreter (@bkirwi)
[ ] #23979 gate new cc cluster sizings behind feature flag (@pH14)
[ ] #23991 buf: Fix running against older main state (@def-)
[ ] #23993 doc/developer: refine feature lifecycle (@benesch)
[ ] #23989 persist-txn: Make apply idempotent on closed shard (@jkosh44)
[ ] #23948 persist-txn: Apply shard forget (@jkosh44)
[ ] #23878 catalog: make the persist impl's schema a single jsonb column Row (@danhhz)
[ ] #23996 persist-txn fix combo of persist fast path plus lazy persist-txn (@danhhz)
[ ] #23999 slt: Use tmpfs for /tmp (@def-)
[ ] #24008 sql: teach subsources about RETAIN HISTORY (@mjibson)
[ ] #23766 [persist] Limit persist peek sizes and add some tests (@bkirwi)
[ ] #23793 doc/user: document configurable group and transactional IDs for Kafka (@benesch)
[ ] #23969 *: fix name of mz_compute_hydration_statuses (@teskje)
[ ] #23967 *: update various feature flag defaults (@teskje)
[ ] #24009 lint: specify yamllint as package (@nrainer-materialize)
[ ] #23977 scalability framework: close plots after saving them (@nrainer-materialize)
[ ] #24012 parallel-workload fixes (@def-)
[ ] #24013 buildkite: Make legacy upgrade wait for build (@def-)
[ ] #24015 storage: report hydration time for all source types (@teskje)
[ ] #23992 test: Set MZ_SYSTEM_PARAMETER_DEFAULT when running bin/sqllogictest (@ParkMyCar)
[ ] #24016 adapter: Add comment describing resolved_ids (@jkosh44)
[ ] #24018 catalog: bump minimum version for persist/shadow catalog in upgrade test (@danhhz)
[ ] #24014 sqlsmith: Limit with expressions (@def-)
[ ] #23987 Use column name instead of index in ASSERT NOT NULL (@umanwizard)
[ ] #23903 sql: Support setting global defaults for some Session variables (@ParkMyCar)
[ ] #24022 persist-txn: tweak debug logging in the operators (@danhhz)
[ ] #23997 environmentd: improve http/ws errors (@mjibson)
[ ] #24021 ci: add git-based legacy-upgrade test to nightly (@nrainer-materialize)
[ ] #24020 catalog: Clean up CatalogKind enum (@jkosh44)
[ ] #24023 sqllogictest: enable persist PubSub in SLT (@benesch)
[ ] #24025 buildkite: Require explicit depends_on in tests pipeline (@def-)
[ ] #24030 ci: Fix format string in ci-regex errors (@def-)
[ ] #24024 persist-txn: Simplify unapplied iterator (@jkosh44)
[ ] #23946 MySQL Create Connection Stub Implementation (@rjobanp)
[ ] #24007 expr/sql: implement MAX/MIN aggregates for interval (@guswynn)
[ ] #24033 postgres-util: prevent warning with building without default features (@guswynn)
[ ] #24038 cargo-test: Reenable test_emit_tracing_notice (@def-)
[ ] #24039 Revert "sql: teach subsources about RETAIN HISTORY" (@mjibson)
[ ] #24040 doc/user: restore blue coloring of public preview notice (@benesch)
[ ] #24017 git utils: do not assume that origin points to the mz repo when running locally (@nrainer-materialize)
[ ] #23984 tests: handle accepted regressions in release builds (@nrainer-materialize)
[ ] #24052 mz_hydration_statuses view (@teskje)
[ ] #24045 buildkite: Fix depends_on (@def-)
[ ] #24031 reclock: fix read hold leak leading to large in-memory traces (@petrosagg)
[ ] #23790 storage: refactor Kafka sink, take 2 (@petrosagg)
[ ] #23674 [adapter / v2] Add a since handle to the new Persist catalog (@bkirwi)
[ ] #23777 webhook: Cache "webhook appender" from Coordinator (@ParkMyCar)
[ ] #24048 catalog: Remove usages of AdapterError (@jkosh44)
[ ] #24054 storage: correctly transition the envelope_state_bytes value when moving moving from memory to rocksdb (@guswynn)
[ ] #24060 coverage: Fix empty services.log (@def-)
[ ] #24049 Move CREATE MATERIALIZED VIEW optimization off the coordinator thread (@aalexandrov)
[ ] #24062 ci: Reenable checks-backup-rollback (@def-)
[ ] #24065 more principled frontier checking to avoid flakes (@petrosagg)
[ ] #24066 ci: Beautify bin/lint (@def-)
[ ] #24064 ci: Try using stdbuf with tee (@def-)
[ ] #24069 ci: Trim unnecessary builds (@def-)
[ ] #24046 In parser change GH action, escape quotes in PR title (@chaas)
[ ] #24070 lint: Don't fix Python formattings using ruff (@def-)
[ ] #24068 Move CREATE VIEW optimization off the coordinator thread (@aalexandrov)
[ ] #24058 release: Add script to cut release (@jkosh44)
[ ] #24077 product-limits: Lower number of cases in CaseWhen scenario (@def-)
[ ] #24078 blns: Remove duplicate strings (@def-)
[ ] #23995 Add new github action when a new builtin indexes is added in a PR (@chaas)
[ ] #24073 catalog: Add comment explaining JSON serialization (@jkosh44)
[ ] #24029 catalog: Add feature flag for catalog kind (@jkosh44)
[ ] #24047 persist-txn tests in Platform Checks (@philip-stoev)
[ ] #24072 Move CREATE INDEX optimization off the coordinator thread (@aalexandrov)
[ ] #24091 zippy: Add a scenario that toggles persist-txn (@philip-stoev)
[ ] #24094 Fix bug in Avro schema resolution with defaulted logical types (@umanwizard)
[ ] #24095 parallel-workload: Expect missing webhook sources (@def-)
[ ] #24097 version consistency: ignore min/max errors (@def-)
[ ] #24096 storage-types: reorganize sources.rs into modules (@petrosagg)
[ ] #24093 adapter,pgwire: allow paging through portals (@benesch)
[ ] #24057 doc/user: polish 80.2 release notes (@jubrad)
[ ] #24103 sql: make interval planning consistent across WITH options and expressions (@benesch)
[ ] #23963 test/checks: improve AWS connection platform checks (@benesch)
[ ] #24107 persist-txn: fix and re-enable maelstrom tests (@danhhz)
[ ] #24092 Move SUBSCRIBE optimization off the coordinator thread (@aalexandrov)
[ ] #24098 avro: address code review follow up from #24094 (@benesch)
[ ] #24114 mzcompose,cloudtest: Make sure the same AWS-related env varibles are … (@philip-stoev)
[ ] #24110 sql+adapter: remove enable_unified_clusters tag (@sploiselle)
[ ] #24120 Fix SQL council github action (@umanwizard)
[ ] #24121 persist: fix 'un-consumed Batch dangling blob keys' log spam (@danhhz)
[ ] #24122 fix quotes in sql council workflow file (@umanwizard)
[ ] #24118 stash: Elevate stuck consolidator priority (@jkosh44)
[ ] #23888 Refresh types while in letrec major (@frankmcsherry)
[ ] #23952 Add and use smarter HIR builders (@frankmcsherry)
[ ] #24129 platform-checks: Fix the UnifiedCluster scenario (@philip-stoev)
[ ] #24087 catalog: Always use catalog migrator implementation (@jkosh44)
[ ] #24123 rename "statement_kind" to "statement_type" (@umanwizard)
[ ] #24131 persist-txn: A dedicated mzcompose test for fencing (@philip-stoev)
[ ] 580d2e024 LICENSE: update change date (@materialize-bot)
[ ] 6c050a6c9 LICENSE: update change date (@materialize-bot)
[ ] 5d8f9d0ef test/restart: fix Python formatting issue (@benesch)
[ ] d5863f350 LICENSE: update change date (@materialize-bot)
[ ] 002437c49 LICENSE: update change date (@materialize-bot)
[ ] ad58d73b8 LICENSE: update change date (@materialize-bot)
[ ] 02f6a7e4d LICENSE: update change date (@materialize-bot)
[ ] 73b635510 LICENSE: update change date (@materialize-bot)
[ ] 2cc0c315d LICENSE: update change date (@materialize-bot)
[ ] 1a7d58399 LICENSE: update change date (@materialize-bot)
[ ] 2c8580f86 LICENSE: update change date (@materialize-bot)
[ ] 1e5f5e4d5 LICENSE: update change date (@materialize-bot)
[ ] 1006f7e51 LICENSE: update change date (@materialize-bot)
[ ] e3126e097 LICENSE: update change date (@materialize-bot)
[ ] 1bf5dd1a8 release: bump to version v0.81.0 (@moulimukherjee)

MaterializeInc / materialize

release: v0.81.0 required reviews #24139