As you can see <u>[here](https://sqlite.org/lang_with.html)</u>, the 3rd line of your query can be altered to either<code> found(id) AS MATERIALIZED ( </code>or<code> found(id) AS NOT MATERIALIZED ( </code>. And by prefacing the query with 'EXPLAIN', you can see the effect of those insertions relative to the non-hinted query.