v0.2.24

Changes

✨ New Features

• [FEAT] Allow returning of pyarrow arrays from UDFs @jaychia (#2252)
• [FEAT] Add left, right, and outer joins @kevinzwang (#2166)
• [FEAT] Add rpad and lpad expressions @murex971 (#2157)
• [FEAT] AWS Profile override in S3Config @samster25 (#2243)
• [FEAT] Add unpivot @kevinzwang (#2204)
• [FEAT] Add string repeat functionality @murex971 (#2198)
• [FEAT] Approximate quantile aggregation (pulled into main) @jaychia (#2179)
• [FEAT] pivot @colin-ho (#2183)

🚀 Performance Improvements

• [PERF] Adaptive Query Execution @samster25 (#2176)
• [PERF]: swap out json_deserializer for simd_json @universalmind303 (#2228)
• [PERF] Evaluate only true/false side of if_else if predicate is boolean @colin-ho (#2222)
• [PERF] enable metadata preservation across materialization points @samster25 (#2216)

👾 Bug Fixes

• [BUG] Fix tab completion on expression namespaced accessors @jaychia (#2251)
• [BUG] route abfss to AzureBlob @samster25 (#2244)

📖 Documentation

• [CHORE] Skip demo notebook @jaychia (#2248)
• [FEAT] Add rpad and lpad expressions @murex971 (#2157)
• [DOCS] Add user guide for read_sql @colin-ho (#2226)
• [FEAT] Add unpivot @kevinzwang (#2204)
• [DOCS] Add read_hudi in the api docs @xushiyan (#2225)
• [FEAT] Add string repeat functionality @murex971 (#2198)
• [DOCS] LinkedIn Big Data meetup tutorial @jaychia (#2223)
• [FEAT] Approximate quantile aggregation (pulled into main) @jaychia (#2179)
• [DOCS] Add read_lance docs @jaychia (#2218)
• [FEAT] pivot @colin-ho (#2183)

🧰 Maintenance

• [CHORE] Drop Python 3.7 @samster25 (#2250)
• [CHORE] Improve timestamp repr @colin-ho (#2245)
• [CHORE] Allow multiple group_bys for pivot @colin-ho (#2242)
• [CHORE] Skip demo notebook @jaychia (#2248)
• [CHORE] Return &str for expression name @colin-ho (#2224)
• [CHORE] Mount provision.py for iceberg integration tests @jaychia (#2232)
• [CHORE]: remove trait aliases @universalmind303 (#2229)

⬆️ Dependencies

• Bump serde from 1.0.198 to 1.0.200 @dependabot (#2239)
• Bump csv-async from 1.2.6 to 1.3.0 @dependabot (#2238)