Ibis Files

10.7.0 (2025-07-27)

Features

• api: add Expr.to_sql() method (#11357) (493d6e5)
• api: always prefer overwriting existing fields when unpacking with overlapping column names (#11470) (8027d51)
• backends: kurtosis (50c3132)
• ux: workaround for spurious display()s in jupyter (58dea60)

Bug Fixes

• api: do not assume that dir produces attributes that exist (#11497) (1a5b1a2)
• athena/trino/bigquery: make temporal diff robust to operand order (857758a)
• datafusion: ensure approx quantile works (195b4f6)
• distinct: allow deleting rows when on is unspecified (#11383) (4902ec6)
• duckdb/snowflake: decouple Pandas and PyArrow backend converters (#11431) (0f7f7c1)
• duckdb: disallow duckdb 1.3.1 due to hangs when loading the geospatial extension (#11409) (a67a244)
• exasol: ensure that rounding is not subverted by sqlglot cast (3aa3d34)
• polars: ensure that memtables can be compiled into LazyFrames by running pre-execute hooks (#11392) (7be448e)
• postgres: make pyarrow round trip of nans and nulls higher fidelity (#11396) (60a5ba9)
• psycopg: avoid specifying the psycopg dependency implementation (#11424) (038c339)
• sql: ensure that CTEs as part of .sql calls are compiled in topological order (#11439) (8e227ac)
• trino/athena: ensure that DateDiff operands are in the correct order (#11434) (e29881c)
• trino/athena: ensure that regex extract compiler dispatch method is spelled correctly (#11436) (944fa99)

Documentation

• improve docs for set ops (#11394) (6521a53)
• replace: clarify types and add link to Value.substitute (#11413) (1c05d2f)
• substitute: add to See Also section to fix rendered formatting (#11412) (d381536)
• to_sql: fix definition package (0b5daea)
• to_sql: fix see also reference from Value.to_sql to ibis.to_sql (7e0042c)
• udfs: add examples of udfs with struct types as inputs (#11385) (0e8a932)

Refactors

• rename to_sqlglot to to_sqlglot_columns_definition (#11455) (0e4cf43)
• sqlite: move sqlite3 imports local to avoid pyodide import issues with non-sqlite backends (#11500) (b8110d3)

Performance

• mutate: skip dereferencing cols preserved in .mutate (#11458) (70de1a1)