title: Microsoft SQL text driver alternatives
body: <p>I have tried <code>Microsoft.Jet.OLEDB.4.0</code> and <code>Microsoft Text Driver</code> and both of these or not standard. I am trying to copy and paste simple sql from our database to these text drivers but i must heavily modify the sql to make it work. I am querying csv and text files. is there anything out there that can handle simple sql queries besides the drivers mentioned above?</p>
  
  <p>Here is a sample of the sql i am working with:</p>
  
  <pre><code>select distinct 
       CASE F1
       WHEN 'a' THEN 'abcd'
       WHEN 'b' THEN 'bcde'
       WHEN 'c' THEN 'cdef'
       WHEN 'e' THEN 'efgh'
       ELSE 'Unkown'
       END AS Alpha1,
       CONCAT('91a',trim(F2)) as Alpha2
  from 1.csv    
  where trim(column1) IS NOT NULL
  </code></pre>