Is there a good way to determine if a sql query is either attempting to modify a database, or simply querying it?
In the past, I have used sqlite3_update_hook with good results, but in this current project, I am looking for a way to determine the type of query even before the prepared statement is stepped thru at all. Ie, based on the query text alone, I want to try to make this determination. Would Explain / [Query Plan] be useful in determining the type of query? Thanks all.