Cannot connect to database or run .sql file

[heelanawabi]

Type: Bug

I have installed the sqlite in my laptop and the sqlite extension by alexcvzz in vs code as well. I can code sqlite in the vscode terminal but when I want go to my command plate>SQLite: Open Database and when I click on the database I get the error attached below. The same thing happens when I want to connect to a database I created myself in the terminal or if I say for example: .read schema.sql I just get 'cannot open "schema.sql"'. I have tried multiple troubleshooting ways learned online, uninstalled and reinstalled the vscode again but nothing seems to fix this problem.Can you please help me find the solution for this error?

error:
Failed to open database 'c:\Users\heela\Desktop\PythonProjects\packages.db': Parse error near line 4: no such column: "table" - should this be a string literal in single-quotes? aster WHERE (type="table" OR type="view") error here ---^

Extension version: 0.14.1
VS Code version: Code 1.96.4 (cd4ee3b1c348a13bafd8f9ad8060705f6d4b9cba, 2025-01-16T00:16:19.038Z)
OS version: Windows_NT x64 10.0.26100
Modes:

System Info

Item	Value
CPUs	Intel(R) Core(TM) Ultra 7 155U (14 x 2688)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	31.45GB (20.38GB free)
Process Argv	--crash-reporter-id e2a2bb71-4829-4ef4-a61d-d93d91694a14
Screen Reader	no
VM	0%

A/B Experiments

vsliv368cf:30146710
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805cf:30301675
binariesv615:30325510
vsaa593cf:30376535
py29gd2263:31024239
c4g48928:30535728
azure-dev_surveyone:30548225
2i9eh265:30646982
962ge761:30959799
pythonnoceb:30805159
pythonmypyd1:30879173
h48ei257:31000450
pythontbext0:30879054
cppperfnew:31000557
dsvsc020:30976470
pythonait:31006305
dsvsc021:30996838
dvdeprecation:31068756
dwnewjupytercf:31046870
newcmakeconfigv2:31071590
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc1:31192215
cf971741:31144450
iacca1:31171482
notype1:31157159
5fd0e150:31155592
dwcopilot:31170013
stablechunks:31184530
6074i472:31201624
dwoutputs:31217127
9064b325:31222308
copilot_t_ci:31222730

[IgorArnaut]

I have the same issue.

[A3RNAV]

Just started experiencing this out of nowhere as well

[avenable11]

The original creator is not maintaining the extension. I have forked it and updated it to fix this issue. You can find my version on the marketplace under SQLite-AV