changelogs.md


googleapis/python-bigquery-sqlalchemy

Repository  -  API  -  Source

1.2.0

September 9, 2021

Features

Bug Fixes

  • the unnest function lost needed type information (#298) (1233182)

1.1.0

August 25, 2021

Features

  • Add geography support (#228) (da7a403)
  • Handle passing of arrays to in statements more efficiently in SQLAlchemy 1.4 and higher (#253) (7692704)

Bug Fixes

  • dialect atribute wasn't provided (#291) (2cf05a0)
  • distinct doesn't work as a column wrapper (#275) (ad5baf8)
  • in-operator literal binds not handled properly (#285) (e06bf74)
  • supports_multivalues_insert dialect option was mispelled (#278) (ec36a12)
  • unnest failed in some cases (with table references failed when there were no other references to refrenced tables in a query) (#290) (9b5b002)

1.0.0

August 17, 2021

Miscellaneous Chores

1.0.0-a1

August 11, 2021

Features

  • Rename pybigquery to sqlalchemy-bigquery (#198) (a6f0a5d)

Miscellaneous Chores

0.10.1

July 30, 2021

Bug Fixes

  • deps: pin 'google-{api,cloud}-core', 'google-auth' to allow 2.x versions (#220) (bf1f47c)

0.10.0

July 6, 2021

Features

  • There's a new page_size option to control the page size used when listing tables. (#174) (e0f1496)

0.9.1

June 25, 2021

Documentation

  • omit mention of Python 2.7 in 'CONTRIBUTING.rst' (d52334c)

0.9.0

May 25, 2021

Features

  • Alembic support (#183) (4d5a17c)
  • Support parameterized NUMERIC, BIGNUMERIC, STRING, and BYTES types (#180) (d118238)

0.8.0

May 21, 2021

Features

0.7.0

May 12, 2021

Features

  • Comment/description support, bug fixes and better test coverage (#138) (fb7c188)
    • Runs SQLAlchemy dialect-compliance tests (as system tests).
    • 100% unit-test coverage.
    • Support for table and column comments/descriptions (requiring SQLAlchemy 1.2 or higher).
    • When executing parameterized queries, the new BigQuery DB API parameter syntax is used to pass type information. This is helpful when the DB API can't determine type information from values, or can't determine it correctly.

Bug Fixes

  • Select expressions no-longer force use of labels (#129) (669b301)

  • Additional fixes, including:

    • Handling of in queries.
    • String literals with special characters.
    • Use BIGNUMERIC when necessary.
    • Missing types: BIGINT, SMALLINT, Boolean, REAL, CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, VARBINARY, DECIMAL
    • Literal bytes, dates, times, datetimes, timestamps, and arrays.
    • Get view definitions.

0.6.1

April 12, 2021

Bug Fixes

  • use project_id property from service account credentials (#120) (ab2051d)

0.6.0

April 6, 2021

Features

  • fetch table and column descriptions during reflection (#115) (7b14a06)

Bug Fixes

0.5.1

April 1, 2021

Bug Fixes

  • avoid 404 if dataset is deleted while listing tables or views (#106) (db379d8)

Documentation

  • add templates for move to googleapis/python-bigquery-sqlalchemy repo (#88) (37e584e)
  • build documentation with Sphinx (#97) (1707737)

0.5.0

November 18, 2020

⚠️ Breaking Changes ⚠️

  • get_table_names() no longer returns views. (#62, #60)

Features

  • Support the ARRAY data type in generated DDL. (#64)
  • Support project ID and dataset ID in schema argument. (#63)
  • Implement get_view_names() method. (#62, #60)

Bug Fixes

  • Ignore no-op nested labels. (#47)

Development

  • Use flake8 for code style checks. (#71)

0.4.15

April 23, 2020

Implementation Changes

  • Prefer explicitly provided dataset over default dataset in lookup. (#53)
  • Use the provided project_id when using a service account. (#52)