v0.9.26

0.9.26 (2024-11-09)

Features

• flatten returns an index column (f603d0c), closes #143
• Support TRUNCATE TABLE description (#144) (234bbaf)

Chores

• bump sqlglot 25.22.0 (3c1f244)
• cruft update (5d09f8b)
• deps-dev: bump pyright from 1.1.378 to 1.1.382 (#142) (a3898ce)
• deps-dev: bump pyright from 1.1.382 to 1.1.387 (#145) (d6058d7)
• deps: update duckdb requirement from ~=1.0.0 to ~=1.1.3 (#150) (ecd4d46)
• deps: update pre-commit requirement from ~=3.4 to ~=4.0 (#147) (5a1f866)
• deps: update ruff requirement from ~=0.6.3 to ~=0.7.2 (#146) (e9ae13a)
• deps: update snowflake-sqlalchemy requirement from ~=1.5.0 to ~=1.6.1 (#119) (89a315a)
• deps: update sqlglot requirement from ~=25.22.0 to ~=25.24.1 (#141) (8e7c343)

v0.9.25

0.9.25 (2024-09-16)

Features

• Adds MERGE INTO transform (#109) (d5e14a7)
• close duckdb connection (223f8e2)
• server: handle snowflake ProgrammingError (9455a43)
• server: support empty result set (b967b69)
• server: support FAKESNOW_DB_PATH (af79f77)
• server: support time & timestamp types (1606a3e)
• support MERGE with multiple join columns and source subqueries (#136) (9b5a7a0), closes #24

Chores

• deps-dev: bump pyright from 1.1.374 to 1.1.378 (#133) (593a420)
• deps: update ruff requirement from ~=0.5.1 to ~=0.6.3 (#130) (6b37d8b)

v0.9.24

0.9.24 (2024-08-21)

Bug Fixes

• don't require pandas at import time (2a7944e), closes #127

v0.9.23

0.9.23 (2024-08-20)

Features

• server: support bool, int, float types (efd4942)
• server: support cur.description (6e9c1a5)
• support conn.is_closed() (36dd461), closes #125

v0.9.22

0.9.22 (2024-08-11)

Features

• DESCRIBE VIEW (b874fc1)
• describe view information_schema.* (facc390)

Bug Fixes

• column types for DESCRIBE (572eaf5)
• fetchmany supports irregular sizes (3115afd)
• log all sql executed (in debug mode) (6faa120)

Chores

• deps: update sqlglot requirement from ~=25.5.1 to ~=25.9.0 (#123) (da78574)

v0.9.21

0.9.21 (2024-08-04)

Features

• alter table cluster by (9a78fc2)

Bug Fixes

• Allow connection with schema=information_schema (#122) (51e4e68)
• columns returned by describe view information_schema.columns (83c62b6)
• Ensure type column in information_schema views is not null (#121) (7340a4a)
• Only set variables for SetItem expressions (#116) (0e0711c)

Chores

• bump sqlglot 25.5.1 (713d93d)
• cruft update (72b791b)
• deps-dev: bump pyright from 1.1.369 to 1.1.374 (#118) (17a8760)

v0.9.20

0.9.20 (2024-07-10)

Features

• SHOW PRIMARY KEYS for table (#114) (2c006b3)

Bug Fixes

• $$ not considered a variable (235fbc1)
• concurrent connection write-write conflict (96ba682)

v0.9.19

0.9.19 (2024-07-08)

Features

• Implements basic snowflake session variables via SET/UNSET (#111) (7696cbd)

Chores

• deps-dev: bump pyright from 1.1.366 to 1.1.369 (#112) (7656ab9)

v0.9.18

0.9.18 (2024-06-29)

Bug Fixes

• execute_string ignores comments (e6513f7)
• Support IF NOT EXISTS in CREATE DATABASE statements (#108) (e7f3f97)

v0.9.17

0.9.17 (2024-06-23)

Features

• SPLIT (28f0d98)

Bug Fixes

• ARRAY_AGG with OVER (6d94c61), closes #92
• flatten VALUE cast to varchar as raw string (818efcc)
• more selective flatten_value_cast_as_varchar (7748fbf)

Chores

• deps: update duckdb requirement from ~=0.10.3 to ~=1.0.0 (#107) (8ead354)
• deps: update sqlglot requirement from ~=24.1.0 to ~=25.3.0 (#106) (89bee6f)