Use SQL in a mutate, when translation is not available

[hershelm]

I would like to use some specific Snowflake JSON extraction functions, which are not yet available in the Snowflake backend. I am wondering if it's possible to insert pure SQL in-line into a mutate() command, as you can in R's dbplyr (see article below):

https://dbplyr.tidyverse.org/articles/sql.html#what-happens-when-dbplyr-fails

Thanks

[gforsyth]

Yep, sure is. You want a scalar udf builtin:
https://ibis-project.org/reference/scalar-udfs.html#ibis.expr.operations.udf.scalar.builtin