How to use parenthesis in laravel sql raw query?

@wilmer.lemke 

In Laravel, you can use parentheses in a raw SQL query by using the DB::raw method. This method allows you to include raw SQL expressions within your query.

Here is an example of how you can use parentheses in a raw query in Laravel:

1
2

$query = "SELECT * FROM users WHERE (age > 18 AND gender = 'male') OR (age < 18 AND gender = 'female')";
$users = DB::select(DB::raw($query));

In the above example, we are selecting all users from the users table where the age is greater than 18 and the gender is male, or the age is less than 18 and the gender is female. The parentheses are used to group the conditions together to ensure the correct logic is applied.

By using DB::raw, you can include any valid SQL expression in your query, including parentheses, without Laravel trying to modify or escape the query. Just be sure to properly sanitize and validate any user input to prevent SQL injection attacks.