In the enterprise environment we are seeing the push to leveraging Snowflake more and more use-cases. I'm a traditionalist that views that for OLAP style analytical workloads that Snowflake is fine, but once you get into OLTP workloads with simple singleton operations (single UPDATE, INSERT, DELETE) that Snowflake will be slow for the users. I realize they have recently released (in-preview) some new tech called Hybrid Tables that aims to solve for both workloads. They also have something called the "Search Optimization Service" to aid in mitigating bottlenecks imposed by wildcard searches.

Does anyone have any experience in this area? Are teams starting to think about building CRUD apps that connect directly to Snowflake? To me it seems like there are some tradeoffs vs a traditional RDBMS.

Thanks