@Ryan Chynoweth​ why do you not recommend using delta lake as a backend for web application? It's meant for OLAP and not OLTP applications, right?

So if we are looking to solve for analytical reports only then would you eliminate relational db or MPP db (like snowflake, synapse , redshift) in lieu of delta lake? Any challenges you foresee in this strategy? anything like data security , fine-grained access controls , lack of foreign key constraint, any thing?

Does the delta table query performance degrade as number of versions grow with every transaction on the table , it creates new version of the table (and keeps it until vacuuming is done routinely )