title: Laravel / Eloquent - How Do You Run Multiple Raw SQL Statements At the Same Time?
body: <p>I have multiple SQL statements I'd like to run through Eloquent.  They look something like this:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE TEMPORARY TABLE cars
      AS (SELECT cars.id, cars.ip_address
          FROM cars
              JOIN colors ON colors.ip_address = cars.ip_address);
  
  CREATE TEMPORARY TABLE boats
      AS (SELECT ip_address, MIN(id) AS id
          FROM colors
          GROUP BY ip_address);
  
  CREATE TEMPORARY TABLE rvs
      AS (SELECT rvs.id, rvs.ip_address
          FROM rvs
              LEFT JOIN colors ON colors.id = rvs.id
          WHERE colors.id IS NULL);
  
  /* Do things with temp tables here */
  </code></pre>
  
  <p>I need all of these statements to run in one connection session since they are using temporary tables.  I've tried using <code>DB::statement()</code> which errors out at the start of the second statement operation and also <code>DB::unprepared()</code> which doesn't seem to run any of the operations.</p>
  
  <p>Is there a way to run multiple raw statements using Eloquent?</p>