search

HGInsights / avalanche

Avalanche is an Elixir Snowflake Connector built on top of the Snowflake SQL API v2.
Apache License 2.0
15 stars 3 forks source link

Support `splice` and `in` #50

Open andyleclair opened 2 months ago

andyleclair commented 2 months ago

Is your feature request related to a problem? Please describe. Avalanche cannot handle where: some_val in ["list", "of", "strings"] or where: fragment("? in (?)", q.col, splice(^list_of_strings)

Describe the solution you'd like It would be great if this was possible. Snowflake supports where val in (some list)

Describe alternatives you've considered I can do a dynamic with or but that is ugly and gross and either in or splice should work

Additional context

Screenshot of the error I get:

image

forest commented 2 months ago

This would be nice. Happy to take PRs.