Level 16
The former creates an in-memory Expression object which you can use in your queries whereas the latter immediately executes any statement/expression you pass along.
2 likes
Dec 19, 2021
7
Level 39
DB::raw vs DB::statement
I just noticed that DB::raw does not return any error, DB::statement (and other cdes) does.
There should be an explanation in the code, but I did not find any note about this in the documentation, neither in the web. Does sb have more information?
Level 39
Thanks @mabdullahsari for the explanation, can you point me/us where this is explain in the doc and if the doc talks about the difference in exception handling?
Level 102
@sr57 not every single detail is mentioned in the docs. So often looking at the source is the way to go
https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Connection.php#L890
Vs
https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Connection.php#L492
And what code would you expect to give an error? Can you show example?
2 likes
Level 39
Thank @Sinnbeck for your reply.
Concerning exception, I don't thing it's a detail, it's not the first time I used raw query, but I was not aware of this before.
Nothing special with my code, it's just a (sql) view creation.
Having a look to the code, it's written that statement returns error, but it's not obvious (for me) that raw does not do it.
Level 102
@sr57 well I don't think laravel docs uses raw for anything other that appending strings to other queries? It does not use them by themself as far as I can tell https://laravel.com/docs/8.x/queries#raw-expressions
So in all those examples, the resulting query will throw the error if one occurs
Level 39
@Sinnbeck You are (probably) right.
I really appreciate Laravel and its documentation.
In this particular case I should add a 2nd remember in bold "In addition of SQL injection vulnerability, be aware that raw expression does not throw exception.
And, personally, I'll replace all my "raw" by "statement"
Level 75
You can still bind your parameters when using Raw. Then it's not raw.
Raw expression is good when eloquent doesn't have an equal.
1 like
Please or to participate in this conversation.