0.9.1 (2024-02-09)
0.9.0 (2024-02-08)
- change to Apache License
- 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)
- 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)
0.8.2 (2024-01-05)
- 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)
- upper/lower converts extracted json to varchar (44cd871)
0.8.1 (2024-01-03)
- add fakesnow cli (13b28df)
- FAKESNOW_DEBUG=1 prints sql commands (e9919b7)
- support fetchmany (382a9bf)
- support FLATTEN (0b6267f)
- 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)
- add notebooks used for development (3055fd4)
- bump sqlglot 20.4.0 (2b216f9)
- bump sqlglot 20.5.0 (6963493)
0.8.0 (2023-12-28)
- support arrays
0.7.1 (2023-12-27)
- No module named 'pandas.core.arrays.arrow.dtype' (6ed1d2a)
0.7.0 (2023-09-09)
0.6.0 (2023-08-19)
- dictionary params (01ce713)
- support describe and info schema for ARRAY and OBJECT (0826d1c)
- to_decimal, to_number, to_numeric (8c19a8b)
- better doc strings (53f798e)
0.5.1 (2023-07-24)
0.5.0 (2023-07-23)
- cursor sqlstate (04aa92e)
- sqlid (18985e9)
- support BINARY type in description and info schema (32d5952)
- support TIME in description & TIMESTAMP in info schema (7014d8d)
- info schema now returns FLOAT types correctly (55d84c1)
- add test coverage for BOOLEAN in info schema (9c4f254)
0.4.1 (2023-07-16)
- remove stray debugging print (0ecc853)
0.4.0 (2023-07-16)
- support indices on variants (8269552)
- support regexp_substr (98abc33)
- very basic rowcount support (d1116d8)
- 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)
- remove unneeded type ignore (5214ff9)
0.3.0 (2023-07-15)
- 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)
- alter table .. add column (612e1aa)
- fetchone() when using DictCursor (e1e50f7)
- match snowflake's integer precision (49afda2), closes #12
- bump sqlglot 16.8.1 (8f30d1a)
0.2.0 (2023-06-24)
- 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)
- 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)