title: Running a .sql file from R
body: <p>I have a few .sql files which aggregate a number of tables/views in a SQL Database. I want to be able to direct R to a specific sql file and execute it and return the results in a dataframe.</p>
  
  <p>Googling around it seems that I can only grab actual tables/views which are in the database or I have to rewrite the sql query and run that through the package RODBC. </p>
  
  <p>In python this can be done with pd.read_sql_query </p>