Issues

• ARRAY_FLATTEN(ARRAY_AGG(x)) fails to bind: ARRAY_AGG returns JSON, flatten takes a list

  tekumara/fakesnow#498 · Filter by author aaron-hurst opened on Nov 3, 2026

• In-process (fakesnow.patch) results differ from the connector's: duplicate column names collapse, BINARY is bytes, the cursor isn't iterable, PUT has one column, no get_query_status

  tekumara/fakesnow#494 · Filter by author THEtheChad opened on Oct 27, 2026

• Server mode: write_pandas fails (COPY from a quoted or string stage reference, INFER_SCHEMA); SELECT from a stage and DROP STAGE aren't supported

  tekumara/fakesnow#493 · Filter by author THEtheChad opened on Oct 27, 2026

• MERGE: table aliases fail with only a WHEN MATCHED clause; duplicate source rows update a target row instead of failing

  tekumara/fakesnow#492 · Filter by author THEtheChad opened on Oct 27, 2026

• DDL inside an explicit transaction doesn't commit it: ROLLBACK discards earlier writes, or the DDL fails (HTTP 500 in server mode)

  tekumara/fakesnow#491 · Filter by author THEtheChad opened on Oct 27, 2026

• DDL status messages, SHOW and INFORMATION_SCHEMA differ from Snowflake: IF [NOT] EXISTS status, SHOW TABLES comment, SHOW COLUMNS nullability, SHOW SCHEMAS LIKE

  tekumara/fakesnow#490 · Filter by author THEtheChad opened on Oct 27, 2026
  1

• Functions that differ or are missing: TRIM with characters, SHA2 512, TO_CHAR number formats, 'on'/'off' to BOOLEAN, LAST_QUERY_ID, CURRENT_TRANSACTION, SYSTEM$TYPEOF

  tekumara/fakesnow#489 · Filter by author THEtheChad opened on Oct 27, 2026

• TIMESTAMP_TZ loses its offset; DATE + INTERVAL is a TIMESTAMP; timestamps cast to VARCHAR lack Snowflake's default format

  tekumara/fakesnow#488 · Filter by author THEtheChad opened on Oct 27, 2026

• FLATTEN ignores OUTER => TRUE and PATH =>, and SEQ is an arbitrary large number

  tekumara/fakesnow#487 · Filter by author THEtheChad opened on Oct 27, 2026

• VARIANT: a string cast or compared to VARIANT is parsed as JSON; TYPEOF returns 'JSON'; OBJECT_CONSTRUCT keeps argument order

  tekumara/fakesnow#486 · Filter by author THEtheChad opened on Oct 27, 2026

• Result metadata: VARCHAR(n) length, literal and COUNT precision, and CTAS column types don't match Snowflake

  tekumara/fakesnow#485 · Filter by author THEtheChad opened on Oct 27, 2026

• Division, AVG and MEDIAN return FLOAT where Snowflake returns NUMBER

  tekumara/fakesnow#484 · Filter by author THEtheChad opened on Oct 27, 2026

• Error codes and SQLSTATEs differ from Snowflake's; some errors aren't ProgrammingError (HTTP 500 in server mode)

  tekumara/fakesnow#483 · Filter by author THEtheChad opened on Oct 27, 2026

• Unquoted names that DuckDB reserves but Snowflake doesn't fail (SEMI, PIVOT, RETURNING, ...)

  tekumara/fakesnow#481 · Filter by author THEtheChad opened on Oct 26, 2026

• LOCALTIMESTAMP returns a TIMESTAMP_NTZ instead of a TIMESTAMP_LTZ

  tekumara/fakesnow#480 · Filter by author THEtheChad opened on Oct 26, 2026

• An unqualified name finds a temporary table from another schema after USE SCHEMA

  tekumara/fakesnow#479 · Filter by author THEtheChad opened on Oct 26, 2026

• NUMBER(38,0) values outside the int64 range can't be written or cast

  tekumara/fakesnow#478 · Filter by author THEtheChad opened on Oct 26, 2026

• ARRAY_CONSTRUCT with an alias raises NotImplementedError (HTTP 500 in server mode)

  tekumara/fakesnow#477 · Filter by author THEtheChad opened on Oct 26, 2026

• CREATE DATABASE and CREATE SCHEMA fail on a quoted name containing a single quote

  tekumara/fakesnow#476 · Filter by author THEtheChad opened on Oct 26, 2026

• CREATE FILE FORMAT fails on a quoted name containing a single quote

  tekumara/fakesnow#475 · Filter by author THEtheChad opened on Oct 26, 2026

• TIMESTAMP_LTZ is described as TIMESTAMP_TZ (type code 7 instead of 6)

  tekumara/fakesnow#463 · Filter by author THEtheChad opened on Oct 26, 2026

• write_pandas ignores quote_identifiers, so names are upper-cased unlike Snowflake

  tekumara/fakesnow#462 · Filter by author THEtheChad opened on Oct 26, 2026

• ARRAY_TO_STRING over ARRAY_CONSTRUCT_COMPACT fails with a binder error

  tekumara/fakesnow#461 · Filter by author THEtheChad opened on Oct 26, 2026

• DATE_TRUNC on a DATE returns a TIMESTAMP, unlike Snowflake

  tekumara/fakesnow#460 · Filter by author THEtheChad opened on Oct 26, 2026

• A failed statement aborts the transaction since 0.12.0 (DuckDB 2.0); later commit drops earlier writes

  tekumara/fakesnow#459 · Filter by author emilhe opened on Oct 26, 2026