$ the-wire · showcase
Spanner clients harden identifier quoting; python-genai deprecates interactions names
By RepoJournal · Filed · About Google · Composed from the cited sources · methodology
Four Spanner identifier-handling fixes closed SQL injection paths and quoting bugs across the base client, DB-API driver, and Django backend, while python-genai moved its agent, webhook, trigger, and environment names out of google.genai.interactions.
fix(spanner): escape identifier delimiters and validate table names (#19052) googleapis/google-cloud-python
Table and schema identifiers were wrapped in backticks or double quotes without escaping embedded delimiter characters, so a crafted table name could break out of its bounds in schema-inspection queries. The fix escapes backticks and backslashes for GoogleSQL and double quotes for the other dialect, and adds table name validation.
fix(spanner): harden identifier escaping in dbapi driver (#19054) googleapis/google-cloud-python
The DB-API driver's escaping helper used a hardcoded reserved-keyword list and simple alphanumeric rules, leaving unlisted keywords unquoted and misparsing multipart names with dots inside already-quoted parts. It now quotes identifiers unconditionally with GoogleSQL backticks, a behavior change for anyone relying on the old selective quoting.
fix(django-google-spanner): harden identifier quoting (#19069) googleapis/google-cloud-python
Django's identifier quoting delegated to the DB-API helper, which in newer versions quotes everything meant for dot-qualified paths, so single identifiers containing dots were split into separate parts. The Django backend now implements single-identifier quoting itself, restoring the SQL shape Django expects.
fix(spanner): quote database names when creating databases (#19053) googleapis/google-cloud-python
CREATE DATABASE statements only quoted the database name when it contained a hyphen, so a name matching a reserved SQL keyword such as default or user, or any hyphen-free name under PostgreSQL dialect, produced a syntax error. Names are now always quoted with backticks for GoogleSQL.
feat: Deprecate non-interactions names in google.genai.interactions. googleapis/python-genai
Agent, webhook, trigger, and environment names exported from google.genai.interactions now emit a DeprecationWarning and may be removed in a future release. The release notes route imports to google.genai.agents, google.genai.webhooks, google.genai.triggers, and google.genai.environments.
[jax] Fix coo_fromdense JVP for padded entries when nse > nnz google/jax
The long tail: JAX stopped falling back to shardy when jax_partitioning is on and errors out in auto_axes and explicit_axes instead, fixed a coo_fromdense JVP that gave padded entries a tangent of Mdot[0, 0] rather than zero when nse exceeds nnz, and python-genai removed the per-line length cap on aiohttp SSE streams and made process_schema resolve $defs per path for recursive anyOf schemas.
Action items
- → Move google.genai.interactions agent, webhook, trigger, and environment imports to google.genai.agents, webhooks, tri... googleapis/python-genai [plan]
- → Check Spanner DB-API and Django identifier quoting before upgrading google-cloud-spanner, which now quotes unconditio... googleapis/google-cloud-python [plan]