queries with variable table names break with prefixes

db_query() calls db_prefix_tables before preg_replace_callback so a query like this will not be prefixed correctly:

db_query("UPDATE {%s} SET ...", $table);

Correct version is (from D6 includes/cache.inc):

db_query("UPDATE {". $table ."} SET ...");