Cacher is the code snippet organizer for pro developers

<?php

$con->table('table_name')->where('name LIKE ?',new \Nette\Database\SqlLiteral($con->getSupplementalDriver()->formatLike('John Doe', 0)));

$con->table('table_name')->get(1)->update(array('updated_at'=>new \Nette\Database\SqlLiteral('NOW()')))

// SET quantity = quantity + 1
array('quantity' => new \Nette\Database\SqlLiteral('quantity + 1'))