I think you are totally right! The VIEW itself is not a "materialized" view, but when the (normal) view is instantiated within a single query it is treated as

I think you are totally right! The VIEW itself is not a "materialized" view, but when the (normal) view is instantiated within a single query it is treated as MATERIALIZED because it is used multiple times in the query execution: https://www.sqlite.org/lang_with.html#materialization_hints https://www.sqlite.org/lang_with.html#materialization_hints