Snowflake Integer Placeholder Replacement

[brentonmallen1]

In the case of a query like:

select
        col1, col2, col3, col4, sum(col5) as sum_col5
    from table_name
    where col_name IN (:10,:11)
    group by 1,2,3,4

I'd like to be able to replace the :10 and :11 placeholders, but with the current kwarg implementation, integers can't be the kwarg name. Is there an approach I could take to replace these keyword placeholders using the exp.replace_placeholders method, while specifying the replacements as kwargs?

Thank you for any insight!

[georgesittas]

Hey @brentonmallen1,

I assume you meant that it's not possible to pass these kwargs by doing replace_placeholders(expr, 10=..., 11=...). To work around this limitation you can just expand a dictionary in Python, like so:

>>> import sqlglot
>>>
>>> sql = """
... select
...         col1, col2, col3, col4, sum(col5) as sum_col5
...     from table_name
...     where col_name IN (:10,:11)
...     group by 1,2,3,4
... """
>>>
>>> sqlglot.exp.replace_placeholders(sqlglot.parse_one(sql), **{"10": "foo", "11": "bar"}).sql()
"SELECT col1, col2, col3, col4, SUM(col5) AS sum_col5 FROM table_name WHERE col_name IN ('foo', 'bar') GROUP BY 1, 2, 3, 4"

[brentonmallen1]

wow, thanks for the fast reply! That's just what I needed, I appreciate it!