SQLite based on the statement, you can find out which table will be affected

Question

given a simple request like

SELECT * FROM test; 

or

 INSERT INTO number VALUES (1, 2); 

I am wondering if it is possible to find out before executing the query and without parsing the operator itself that the test table is read in the first query and that the number table is written in the second query.

These two examples are clearly extremely simple, but I'm looking for something that works in more complex cases.

Greetings