tekumara / fakesnow

Fake Snowflake Connector for Python. Run, mock and test Snowflake DB locally.
Apache License 2.0
108 stars 10 forks source link

feat: Implements basic snowflake session variables via SET/UNSET #111

Closed jsibbison-square closed 4 months ago

jsibbison-square commented 4 months ago

Implements the very basic usages of sql variables

SET var2 = 'blue';
SELECT * from table where color = $var2;                  Produces: SELECT * from table where color = 'blue';
UNSET var2;

as described in https://docs.snowflake.com/en/sql-reference/session-variables.

List of features supported and not supported by this PR:

jsibbison-square commented 4 months ago

These comments make sense. I'll work through these changes and notify you when its ready for review again.

jsibbison-square commented 4 months ago

@tekumara I've made updates from all the comments I believe this is ready for review again :).

tekumara commented 4 months ago

Prefect thank you!