Even the praised dbt is just a hack to make declarative incremental because the SQL capabilities of these databases is also bad and you need to template out your way in.
There will once be a SQL database that will make these things not suck and collapse this entire hot space of startups for data loading and missing features in Snowflake.
Snowflake will go away too if they keep ignoring so many "missing features" startups and not improving their loading or language capabilities. Unless they intend to spin up an ecosystem of "hacks" to complement Snowflake to make it usable, which is another reason for some saner system to displace them.