Release 9.5.0 · ibis-project/ibis

9.5.0 (2024-09-11)

api: add name argument to topk (1652076)
api: add name argument to value_counts (24be184)
api: add to_sqlglot method to Schema objects (#10063) (9488115)
mssql: add lpad and rpad ops (#10060) (77af14b)
mssql: add startswith and endswith ops (17a628c)

backends: pass kwargs to _from_url() in every case (#10003) (9ca92f0)
bigquery: handle column name mismatches and _TABLE_SUFFIX everywhere (5ade49e)
clickhouse: fix lstrip, rstrip, and strip (d2539c4)
datafusion: raise when attempting to create temp table (#10072) (1cf5439)
deps: update dependency fsspec to <2024.9.1 (#10036) (ea71719)
deps: update dependency sqlglot to >=23.4,<25.20 (#10010) (ba07da7)
deps: update dependency sqlglot to >=23.4,<25.21 (#10050) (422d361)
docs: update invalid read_parquet link (2ae9ef4)
duckdb: allow setting auto_detect to False by fixing translation of columns argument (#10065) (883d2d3)
duckdb: free memtables based on operation lifetime (#10042) (a121ab3)
duckdb: support version 1.1.0 (#10037) (3a37626)
flink: fix strip (01117a5)
impala: allow specifying temp=False in create_table (e29712c)
impala: fix lstrip, rstrip, strip (413df3b)
mssql: ensure that dot-sql can be executed when column names are not provided (#10028) (1936437), closes #10025
mssql: fix strip, lstrip, rstrip (f53feab)
oracle: fix lstrip, rstrip, and strip (3f5a304)
pandas: don't silently ignore result column name mismatches (48be246)
polars: support polars Enum type (#10017) (869829f)
sqlite: list temporary tables by default (#10058) (dfa55b6)
sql: properly parenthesize binary ops containing named expressions (5c2eadc)

backends: clean up resources produced by memtable (#10055) (019cae5)
backends: split memtable existence check out (#10053) (77448bf)
datafusion: avoid reinitializing memtables on every execute call (#10057) (43e5f12)
dependencies: make fsspec a test-only dependency (37e4439)
formats: plumb through data_mapper and schema in both pandas and pyarrow formats (cbeb967)
mssql: simplify lpad and rpad ops (#10085) (ef5d58d), closes /github.com/ibis-project/ibis/pull/10060#discussion_r1752665235
polars: handle memtables like every other backend (#10056) (2b0dbb9)

backends: speed up most memtable existence checks (#10067) (a205ab7)
ir: don't recreate nodes in replace if their children haven't changed (ac79604)
sql: avoid parenthesizing chains of commutative operators (f86515c)

api: deprecate bool_val.negate()/-bool_val in favor of ~bool_val (499fc03)
api: deprecate filtering/expression projection in Table.__getitem__ (62c63d2)
selectors: deprecate c and r selectors in favor of cols and index (29b865e)