That’s correct. > When the EXPLAIN keyword appears by itself it causes the statement to behave as a
That’s correct.
https://www.sqlite.org/lang_explain.html
When the EXPLAIN keyword appears by itself it causes the statement to behave as a query that returns the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present. When the EXPLAIN QUERY PLAN phrase appears, the statement returns high-level information regarding the query plan that would have been used.
https://www.sqlite.org/lang_explain.html



