Python Polars 0.19.7

🏆 Highlights

• Postfix rolling expression as a special case of window functions. (#11445)
• Use IPC for (un)pickling dataframes/series (#11507)

🚀 Performance improvements

• early return in replace_time_zone if target and source time zones match (#11478)
• greatly improve parquet cloud reading (#11479)
• ensure we download row-groups concurrently. (#11464)

✨ Enhancements

• support left and right anti/semi joins from the SQL interface (#11501)
• Add left_on and right_on parameters to df.update (#11277)
• expressify peak_min/peak_max (#11482)
• IN(subquery) and SQL Subquery Infrastructure (#11218)
• add ODBC connection string support to read_database (#11448)
• postfix rolling expression as a special case of window functions. (#11445)
• allow for "by" column to be of dtype Date in rolling_* functions (#11004)
• rework ColumnFactory to additionally support tab-complete for col in IPython (#11435)

🐞 Bug fixes

• literal hash (#11508)
• Fix lazy schema for cut/qcut when allow_breaks=True (#11287)
• correct output schema of hive partition and projection at scan (#11499)
• correct projection pushdown in hive partitioned read (#11486)
• fix for write_csv when using non-default "quote" char (#11474)
• fix deserialization of parquets with large string list columns causing stack overflow (#11471)
• enable read_database fallback for Snowflake warehouses/connections that don't support Arrow resultsets (#11447)
• Fix SQL ANY and ALL behaviour (#10879)
• partially address some PyCharm tooltip/signature issues with decorated methods (#11428)
• address multiple issues caused by implicit casting of is_in values to the column dtype being searched (#11427)

🛠️ Other improvements

• minor changes in peak-min/max (#11491)
• align cloud url regex in rust and python (#11481)
• Test sdist before releasing (#11494)
• Unpin maturin version, fix release workflow (#11483)
• More release workflow refactor (#11472)
• Set some env vars for release (#11463)
• move repeat_by to polars-ops (#11461)
• upgrade to nightly-10-02 (#11460)
• Update contributing guide to include memory requirement (#11458)
• add missing docs entry for rolling (#11456)
• use with_columns in shift examples (#11453)
• Add wheels as assets to GitHub release (#11452)
• Build more wheels for polars-lts-cpu/polars-u64-idx (#11430)

Thank you to all our contributors for making this release possible!
@ByteNybbler, @MarcoGorelli, @SeanTroyUWO, @alexander-beedie, @c-peters, @dependabot, @dependabot[bot], @mcrumiller, @orlp, @ritchie46, @romanovacca, @stinodego, @svaningelgem and Romano Vacca