Laravel dispone de ditintos  métodos para realizar consultas con bases de datos SQL:

Ejemplos de consultas a tabla en Laravel con Query Builder:

DB::table()->insert();
DB::table()->delete();
DB::table()->update();
DB::table()->select()

Ejemplos de consultas mysql en Laravel con QueryBuilder:

DB::insert("inser into user (name) values($name)");
DB::select("select id from users where name=$name");

DB::insert("insert into user (name) values(?)",[$name]);
DB::insert("insert into user (name) values(:name)",["name"=>$name]);
DB::select("select  id from users where name=?",[$name]);

$query = DB::table("user")->select("id")->take(1)->get(); 
//el método take indica la cantidad de resultados
//first() devuelve el resultado como objeto
print_r($query->first());

DB::table("user")->select("id","name")->where("user","Manuel")->first();
DB::table("user")->where("user","Manuel")->first();
DB::table("user")->where("user"=>"Manuel")->first();
DB::table("user")->where("user"=>"Manuel")->value(id);
DB::table("user")->whereName("Manuel")->first();

\App\Models\User::create([   
    "name"=>"Xip",
    "email"=>"mundaxip@gmail.com",
    "password"=>bcrypt("laravel"),
]);