title: Two database connection in one query in Laravel
body: <p>I need to use INSERT INTO...SELECT but using two different database in Laravel. Database A is a local database. Database B is a remote database. </p>
  
  <p>I need something like this :</p>
  
  <pre><code>INSERT INTO local.table1
  SELECT * 
  FROM remote.table1
  ON DUPLICATE KEY UPDATE col1=col1
  </code></pre>
  
  <p>Is there any way I could achieve this in laravel? Thanks!</p>