>Once you need something complicated, you're on your own, while being stuck in a proprietary environment that you cannot extend.
Snowflake supports enough SQL constructs to allow for very complicated queries. If that doesn't suit your needs then there's stored procedures and custom javascript UDFs you can write. That covers probably 99+% of the use cases at most companies and usually the rest can be done somewhere else on pre-aggregated data.
1. Why tf would javascript be picked as the UDF language when Python dominates the data world.
2. People usually load complex Python libraries for data processing. I wonder if Snowflake UDF would support that or just allow you to use standard library.
1. why not? it's not like you're getting external libraries either way.
2. if you want complex libraries, you can use external functions (aws lambdas, etc) in Snowflake.
Snowflake supports enough SQL constructs to allow for very complicated queries. If that doesn't suit your needs then there's stored procedures and custom javascript UDFs you can write. That covers probably 99+% of the use cases at most companies and usually the rest can be done somewhere else on pre-aggregated data.