snowflakedb/snowflake-jdbc

SNOW-1045676: Update getSQLKeywords to match actual reserved keywords in Snowflake

Closed this issue · 3 comments

What is the current behavior?

The getSQLKeywords method returns a list of keywords that does not match the Snowflake documentation and restricts words that are actually allowed in Snowflake, such as NAME.

It also does not include keywords, such as ILIKE, that are restricted by Snowflake.

What is the desired behavior?

The method should return the accurate list of reserved keywords.

How would this improve snowflake-jdbc?

Applications that use this metadata to restrict keywords would have the accurate information available.

References, Other Background

Snowflake Reserved and Limited Keywords

Hello @dahoorma ,

Thank you raising this issue, we confirmed the gap, we will work on eliminating it.

Regards,
Sujan

Hello @dahoorma ,

PR is currently under review #1670

Regards,
Sujan

PR is merged and just checked, apparently part of the 2024 April release (v3.16.0) which was just released yesterday.