use DB::join to create join object;
left() and right() are non-static method calls.
write something about sub queries in the README.
use sub queries in update and insert values.