Skip to content

Latest commit

 

History

History
316 lines (174 loc) · 17.8 KB

CHANGELOG.md

File metadata and controls

316 lines (174 loc) · 17.8 KB
Raw

Changelog

0.9.6 (2024-03-24)

Features

  • support sqlalchemy metadata reflection (#55) (904156c)

Chores

  • add ruff-format (cruft update) (46fd572)
  • deps-dev: bump pyright from 1.1.330 to 1.1.355 (#58) (9060a2e)

0.9.5 (2024-02-23)

Features

  • SHOW PRIMARY KEYS + description for CREATE VIEW + fix information_schema.columns to work with sqlalchemy (#52) (ff0ab13)

Bug Fixes

  • GET_PATH has higher precedence than comparison operators (91c57a5), closes #53

0.9.4 (2024-02-18)

Features

  • implement information_schema.views (#50) (c6d0bab)

0.9.3 (2024-02-17)

Features

  • connection close (2715d04), closes #45
  • support snowflake.connector.paramstyle (524d136), closes #46

0.9.2 (2024-02-15)

Features

0.9.1 (2024-02-09)

Features

0.9.0 (2024-02-08)

⚠ BREAKING CHANGES

  • change to Apache License

Features

  • cursor.rowcount now returns count (8a8264e)
  • DESCRIBE TABLE (7d0d3a7)
  • EQUAL_NULL (f108a36)
  • extract column comments (27ff048)
  • include params in debug output (7452756)
  • SHOW OBJECTS (84e16e8)
  • SHOW SCHEMAS (74cd1a7)
  • SHOW TABLES (56f6a0b), closes #38
  • support description for TIMESTAMP WITH TIME ZONE (40a3a1e)
  • support description without db/schema + dropping current schema (3315d99)
  • support on-disk databases (6043f3d)
  • UPDATE returns number of rows updated (f1187b1)

Bug Fixes

  • casing in description() (db35a5d)
  • cli passes -m and -d to target (83254d3)
  • COMMENT ON supports raw string (50f0253)
  • FAKESNOW_DEBUG=snowflake corrupting sql (81d7e3c)
  • SHOW OBJECTS shows information_schema objects (6318881)
  • store result set per results set (69f00a6)
  • TO_DATE(VARCHAR) (c5b5d7b)
  • write_pandas supports dicts with different keys (5962801)

Chores

0.8.2 (2024-01-05)

Features

  • FAKESNOW_DEBUG=snowflake prints original snowflake sql statement (42db788)
  • support ARRAY_SIZE (c35d14b)
  • support GET_PATH on nested json (7430067)
  • support IDENTIFIER (a40ac61)
  • support OBJECT_CONSTRUCT_KEEP_NULL (47168fb)
  • support RANDOM (93c2a07)
  • support ResultBatch.to_pandas() (4bfbf45)
  • support SAMPLE (437343f)
  • support TO_TIMESTAMP_NTZ (e351fee)

Bug Fixes

  • upper/lower converts extracted json to varchar (44cd871)

0.8.1 (2024-01-03)

Features

Bug Fixes

  • description for CREATE DATABASE (6015ac8)
  • description for CREATE SCHEMA (f9b1a4d)
  • description for CREATE TABLE (8e8374a)
  • description for DROP statements (a3da822)
  • description for INSERT (ef93ad3)
  • flatten order matches array (fc3d24f)
  • handle commit without transaction (d939b43)
  • handle rollback outside transaction (af0d7ab)
  • notebook no active connection (d60f5db)

Chores

  • add notebooks used for development (3055fd4)
  • bump sqlglot 20.4.0 (2b216f9)
  • bump sqlglot 20.5.0 (6963493)

0.8.0 (2023-12-28)

⚠ BREAKING CHANGES

  • support arrays

Features

Chores

0.7.1 (2023-12-27)

Bug Fixes

  • No module named 'pandas.core.arrays.arrow.dtype' (6ed1d2a)

Chores

0.7.0 (2023-09-09)

Features

  • add information_schema.databases (6953d00), closes #22

0.6.0 (2023-08-19)

Features

  • dictionary params (01ce713)
  • support describe and info schema for ARRAY and OBJECT (0826d1c)
  • to_decimal, to_number, to_numeric (8c19a8b)

Chores

0.5.1 (2023-07-24)

Bug Fixes

  • describe on INTEGER column type in info schema (652525d), closes #16

0.5.0 (2023-07-23)

Features

  • cursor sqlstate (04aa92e)
  • sqlid (18985e9)
  • support BINARY type in description and info schema (32d5952)
  • support TIME in description & TIMESTAMP in info schema (7014d8d)

Bug Fixes

  • info schema now returns FLOAT types correctly (55d84c1)

Chores

  • add test coverage for BOOLEAN in info schema (9c4f254)

0.4.1 (2023-07-16)

Bug Fixes

  • remove stray debugging print (0ecc853)

0.4.0 (2023-07-16)

Features

  • support indices on variants (8269552)
  • support regexp_substr (98abc33)
  • very basic rowcount support (d1116d8)

Bug Fixes

  • dataframe integer columns are int64 (13d36df)
  • info schema now returns NUMBER for numeric types (b108110)
  • info schema now returns TEXT for text types (3ea4f5f)
  • support parse_json on values columns (d5198b8)

Chores

  • remove unneeded type ignore (5214ff9)

0.3.0 (2023-07-15)

Features

  • info schema columns returns lengths for text types (edb91e5), closes #11
  • support ALTER TABLE .. SET COMMENT (6470bae)
  • support setting the timezone (228e884)
  • support timestamp_ntz(9) as a table column (ef28927)
  • treat float as 64 bit (cce50ba)

Bug Fixes

  • alter table .. add column (612e1aa)
  • fetchone() when using DictCursor (e1e50f7)
  • match snowflake's integer precision (49afda2), closes #12

Chores

0.2.0 (2023-06-24)

Features

  • support commit and rollback on connection (c5520b0), closes #6

Bug Fixes

  • describe to work with parameterized SQL queries (#7) (1adaad0)
  • No module named 'pandas' when using pdm (f60d45d), closes #5

0.1.0 (2023-06-20)

Features

  • cursor description (d7d0bb3)
  • describe supports more column types (b16175d)
  • support executemany (94f17b2)
  • support object_construct (6d3e82a)
  • support pyformat style params (3ba53f9)
  • support write_pandas for dataframes with dict values (ba210cd)
  • support write_pandas with partial columns (02fd6a4)
  • to_date supports timestamp(9) (2263430)

Bug Fixes

  • don't order object keys alphabetically (cbef428)
  • object_construct now supports different types (fa50752)
  • remove docformatter (890f1df), closes #1

Documentation