Select data with raw queries

- [Instructor] While Laravel query builder…makes our life easier by creating queries for us,…sometimes we just need a good old-fashioned raw query.…Fortunately, Laravel gives us the flexibility…to be able to feed eloquent raw queries.…Raw queries should be used to execute…complex SQL statements,…because trying to get the eloquent query builder…to do it for us may become cumbersome.…Having said that, let's still check out an example…of raw queries for the complicated situation…where we want to get available rooms within a date range.…

So we first SELECT by a date range…and rooms that have been booked within those dates.…To get the available rooms…we need to get the rooms that are not in the first query.…And finally, we need to ORDER BY id.…This last one is optional.…So now let's do the same query, but on Laravel.…So let's open our Room model.…We'll type ctrl + p or cmd + p…and type Room.…

Let's first import the database facade.…Let's copy line five and paste it…and remove the Database Eloquent Model…and replace it with Support\Facades\DB.…