Hello @agustinsaezm and welcome to the forums!
Would you be able to share the setup of your queries and their Advanced tabs? In each query there is an option for caching results that may have been enabled.
Also, if you are looking for a way to execute a statement without using the setting in the resource to disable converting to a prepared statement you can create a JS Query to "prepare" your statements and then EXEC the returned string (Dynamically generated SQL query in Retool - #2 by pyrrho). This will also let you check on the values being passed directly to the query.