title: ImportError: Using URI string without sqlalchemy installed, while executing REGEXP function on pandas SQL API with SqlLite
body: <p>I am trying to execute REGEXP Funtion of SqlLite using Pandas SQL API, but getting an error of</p>
  <blockquote>
  <p>&quot;ImportError: Using URI string without sqlalchemy installed.&quot;ohon</p>
  </blockquote>
  <p>The python code is as follows :</p>
  <pre><code>import pandas as pd
  import csv, sqlite3
  import json, re
  
  conn = sqlite3.connect(&quot;:memory:&quot;)
  
  print(sqlite3.version)
  print(sqlite3.sqlite_version)
  
  
  def regexp(y, x, search=re.search):
      return 1 if search(y, x) else 0
  
  
  conn.create_function(&quot;regexp&quot;, 2, regexp)
  df = pd.read_json(&quot;idxData1.json&quot;, lines=True)
  df.to_sql(&quot;temp_log&quot;, conn, if_exists=&quot;append&quot;, index=False)
  
  rsDf = pd.read_sql_query(
      conn, &quot;&quot;&quot;SELECT * from temp_log WHERE user REGEXP 'ph'&quot;&quot;&quot;, chunksize=20,
  )
  
  for gendf in rsDf:
      for item in gendf.to_dict(orient=&quot;records&quot;):
          print(item)
  </code></pre>
  <p>The error it throws is</p>
  <pre><code>   raise ImportError(&quot;Using URI string without sqlalchemy installed.&quot;)
  ImportError: Using URI string without sqlalchemy installed.
  </code></pre>
  <p>Can anyone suggest what I am missing. Please not that I have a specific requirement of using Pandas SQL API.</p>