snowflake.snowpark.functions.sql_expr¶

snowflake.snowpark.functions.sql_expr(sql: str) → Column[source]¶

Creates a Column expression from raw SQL text. Note that the function does not interpret or check the SQL text.

Example::

>>> df = session.create_dataframe([[1, 2], [3, 4]], schema=["A", "B"])
>>> df.select(sql_expr("a + 1").as_("c"), sql_expr("a = 1").as_("d")).collect()  # use SQL expression
[Row(C=2, D=True), Row(C=4, D=False)]

Copy