Using a table-alias in Kohana queries?
$result = $this->db ->select("ci.chapter_id, ci.book_id, ci.chapter_heading, ci.chapter_number") ->from("'chapter_info' AS ci") ->where(array("ci.chapter_number" => $chapter, "ci.book_id" => $book)) ->get();
That should work. As you must wrap the original table name in quotes first before the AS keyword and the new table name you want to shorten it to.