This is not a problem for "row stores" though, it's specific to SQLite. As a matter of fact, any classical RDBMS can effectively store columns off-page and and

This is not a problem for "row stores" though, it's specific to SQLite. As a matter of fact, any classical RDBMS can effectively store columns off-page and and most of them do just that in the case of large TEXT/JSON/BLOB columns. Column stores like Redshift, Snowflake, etc. are optimized for a much narrower set of use cases. The more widely used databases could do the same optimizations internally but that would make them much less useful.