…() (#2138)

* change to ai.generate

* perf: Default to interactive display for SQL in anywidget mode

Previously, SQL queries in anywidget mode would fall back to deferred execution, showing a dry run instead of an interactive table.

This change modifies the display logic to directly use the anywidget interactive display for SQL queries, providing a more consistent and responsive user experience. A test case has been added to verify this behavior.

* fix: resolve double printing issue in anywidget mode

* feat: Add test case for STRUCT column in anywidget

Adds a test case to verify that a DataFrame with a STRUCT column is
correctly displayed in anywidget mode.

This test confirms that displaying a STRUCT column does not raise an
exception that would trigger the fallback to the deferred representation.
It mocks `IPython.display.display` to capture the `TableWidget` instance
and asserts that the rendered HTML contains the expected string
representation of the STRUCT data.

* fix presubmit

* Revert accidental changes to test_function.py

* revert accidental change to blob.py

* change return type

* add todo and revert change

* Revert "add todo and revert change"

This reverts commit 153e1d203c273d6755623b3db30bd2256a240cc1.

* Add todo

* Fix: Handle JSON dtype in anywidget display

This commit fixes an AttributeError that occurred when displaying a
DataFrame with a JSON column in anywidget mode. The dtype check
was incorrect and has been updated. Additionally, the SQL compilation
for casting JSON to string has been corrected to use TO_JSON_STRING.

* revert a change

* revert a change

* Revert: Restore bigframes/dataframe.py to state from 42da847

* remove anywidget from early return, allow execution proceeds to _repr_html_()

* remove unnecessary changes

* remove redundant code change

* code style change

* tescase update

* revert a change

* final touch of notebook

* fix presumbit error

* remove invlaid test with anywidget bug fix

* fix presubmit

* fix polar complier

* Revert an unnecessary change

* apply the workaround to i/O layer

* Revert scalar_op_registry.py chnage

* remove unnecessary import

* Remove duplicate conversation

* revert changes to test_dataframe.py

* notebook update

* call API on local data for complier.py

* add more testcase

* modfiy polars import

* fix failed tests

* chore: Migrate minimum_op operator to SQLGlot (#2205)

* chore: Migrate round_op operator to SQLGlot (#2204)

This commit migrates the `round_op` operator from the Ibis compiler to the SQLGlot compiler.

* fix: Improve error handling in blob operations (#2194)

* add error handling for audio_transcribe

* add error handling for pdf functions

* add eror handling for image functions

* final touch

* restore rename

* update notebook to better reflect our new code change

* return None on error with verbose=False for image functions

* define typing module in udf

* only use local variable

* Refactor code

* refactor: update geo "spec" and split geo ops in ibis compiler (#2208)

* feat: support INFORMATION_SCHEMA views in `read_gbq` (#1895)

* feat: support INFORMATION_SCHEMA tables in read_gbq

* avoid storage semi executor

* use faster tables for peek tests

* more tests

* fix mypy

* Update bigframes/session/_io/bigquery/read_gbq_table.py

* immediately query for information_schema tables

* Fix mypy errors and temporarily update python version

* snapshot

* snapshot again

* Revert: Unwanted code changes

* Revert "Revert: Unwanted code changes"

This reverts commit db5d8ea04ee3e8a6382ac546764aff0f6880f66b.

* revert 1 files to match main branch

* Correctly display DataFrames with JSON columns in anywidget

* add mis-deleted comment back

* revert unnecessary change

* move helper function to dtypes.py

* revert unnecessary testcase change

* Improve JSON type handling for to_gbq and to_pandas_batches

* Remove unnecessary comment

* Revert bigframes/dtypes.py and mypy.ini to main branch version

---------

Co-authored-by: jialuoo <jialuo@google.com>
Co-authored-by: Tim Sweña (Swast) <swast@google.com>

🤖 I have created a release *beep* *boop*
---


##
[2.29.0](google/bigframes@v2.28.0...v2.29.0)
(2025-11-10)


### Features

* Add bigframes.bigquery.st_regionstats to join raster data from Earth
Engine
([#2228](google/bigframes#2228))
([10ec52f](google/bigframes@10ec52f))
* Add DataFrame.resample and Series.resample
([#2213](google/bigframes#2213))
([c9ca02c](google/bigframes@c9ca02c))
* SQL Cell no longer escapes formatted string values
([#2245](google/bigframes#2245))
([d2d38f9](google/bigframes@d2d38f9))
* Support left_index and right_index for merge
([#2220](google/bigframes#2220))
([da9ba26](google/bigframes@da9ba26))


### Bug Fixes

* Correctly iterate over null struct values in ManagedArrowTable
([#2209](google/bigframes#2209))
([12e04d5](google/bigframes@12e04d5))
* Simplify UnsupportedTypeError message
([#2212](google/bigframes#2212))
([6c9a18d](google/bigframes@6c9a18d))
* Support results with STRUCT and ARRAY columns containing JSON
subfields in `to_pandas_batches()`
([#2216](google/bigframes#2216))
([3d8b17f](google/bigframes@3d8b17f))


### Documentation

* Switch API reference docs to pydata theme
([#2237](google/bigframes#2237))
([9b86dcf](google/bigframes@9b86dcf))
* Update notebook for JSON subfields support in to_pandas_batches()
([#2138](google/bigframes#2138))
([5663d2a](google/bigframes@5663d2a))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>