title: Convert SQL Server queries to Postgres on the fly
body: <p>I have a scenario where I get queries on a webservice that need to be executed on a database. </p>
  
  <p>The source for these queries is from a physical device so I cant really change the input to my queries.</p>
  
  <p>I get the queries from the device in MSSQL. Earlier the backend was in SQL Server, so things were pretty straight forward. Queries would come in and get executed as is on the DB. </p>
  
  <p>Now we have migrated to Postgres and we don't have to the option to modify the input data (SQL queries). </p>
  
  <p>What I want to know is. Is there any library that will do this SQL Server/T-SQL translation for me so I can run the SQL Server queries through this and execute the resulting Postgres query on the database. I searched a lot but couldn't find much that would do this. (There are libraries that convert schema from one to another but what I need is to be able to translate SQL Server queries to Postgres on the fly)</p>
  
  <p>I understand there are quite a bit of nuances that will be different between SQL and postgres so a translator will be needed in between. I am open to libraries in any language(that preferably runs on linux : ) ) or if you have any other suggestions on how to go about this would also be welcome.</p>
  
  <p><br/></p>
  
  <p>Thanks!</p>