The current implementation of the query detection is rather naive, and doesn't consider complex queries, like UPDATE...SELECT queries and other nested queries. It would be very beneficial if the parse tree (AST) is retrieved and walked to decide which cached responses to invalidate and which not.
The current implementation of the query detection is rather naive, and doesn't consider complex queries, like
UPDATE...SELECTqueries and other nested queries. It would be very beneficial if the parse tree (AST) is retrieved and walked to decide which cached responses to invalidate and which not.