FuelPHP Forums

Is it possible to build the query with the query builder, without executing the query? To make it more clear, let's say I have:

$q = DB::select()->from('products');

Now I want the resulting query, in this case:

SELECT * FROM `products`

But I don't want the DB Class to execute the query and get all the products. Why not? When I have the exact query, I can check in the APC cache if this database query has already been executed and if so, it gets the results from the APC cache, not from the database. If not, the query executes and its results will be saved as:

Cache::set(md5(DB::last_query()), $data_from_db));