get a value eloquent code example

Example 1: laravel eloquent get column

//return array of json
Model::where('id', 1)->get(['column1','column2']);
or
Model::all(['column1']);
//return array
Model::whereNull('deleted_at')->pluck('column1');

Example 2: laravel get sql query eloquent with parameters

$query->toSql();

$query->getBindings()