FeatureFuel
1

Snowflake wrapper does not quote identifiers, causing failures with mixed-case column names

Source: supabase/supabase#40991 · opened by @mattgranado
Bug Description The Snowflake wrapper does not quote column identifiers when generating SQL queries, which causes query failures when Snowflake tables/views have mixed-case column names. Current Behavior When I query a foreign table mapped to a Snowflake view with mixed-case columns like "PK_Well" or "API Number", I get this error: ERROR: HV000: guest fdw error: HTTP status error (422 Unprocessable Entity) Checking Snowflake's query history shows: SQL compilation error: error line 1 at position 7 invalid identifier 'PK_WELL' The wrapper is generating unquoted SQL: Reproduction Root Cause In wasm-wrappers/fdw/snowflake_fdw/src/lib.rs, the deparse() method doesn't quote identifiers: Proposed Fix Also quote table names, WHERE clause columns, and ORDER BY columns. Impact This affects Snowflake shared databases and data marketplace providers that use mixed-case column names (ve…

No pledges yet. Be the first to back this.

Make a pledge

Pledge your monetary support if this feature is added.

$

Comments

No comments yet.

Replying to

Add a comment

What do you think about this feature request?


Similar requests