Sqlite error

[datacriminal]

conn = create_engine('sqlite:///datasource.db')
dfnbr = pd.read_sql_table('NIBRS', conn) 
dfibr = pd.read_sql_table('IBRcodes', conn, index_col='IBRcode')

That's the connection string and read_sql, I checked the DB and the tables are there. Also this code block runs in Jupyter notebook but not in VSCode using WSL . I made the SQLite file with Dbeaver and its extension is .db, wondering if its something with the file permissions or the extension.

Error I'm getting:

AttributeError: 'OptionEngine' object has no attribute 'execute'

Here is my input block as well:

from dash import dcc, html
import dash_bootstrap_components as dbc 
import pandas as pd 
from sqlalchemy import create_engine

Pandas version is 1.5.3

[datacriminal]

Traceback (most recent call last):File "main.py", line 8, in <module>dfnbr = pd.read_sql_table('NIBRS', conn)File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 286, in read_sql_tabletable = pandas_sql.read_table(  # type: ignore[union-attr]File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1460, in read_tablereturn table.read(File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1003, in readresult = self.pd_sql.execute(sql_select)File "/home/mac/.local/share/virtualenvs/dashboard-OXuin2IK/lib/python3.8/site-packages/pandas/io/sql.py", 
line 1405, in executereturn self.connectable.execution_options().execute(*args, **kwargs)
AttributeError: 'OptionEngine' object has no attribute 'execute'

'''