Increase SQLite Version

[pkkid]

Currently it looks like SQL Tools uses SQLite v3.39.3 which is about two years old. I'm hitting some errors using features in SQL Tools that are not available in the version of SQLite available from this extension.

In my specific case, I am using ORDER BY in an aggregate function on an SQLite View. I can not even open SQLTools with my database as it breaks trying to read the view. This functionality was added in SQLite v3.44.0.

Is there a way to use a higher version of SQLite, or a local version of sqlite3 rather than the bundled version?

[RandomFractals]

@pkkid You can try our SQLite Pro Tools driver. It uses node-sqlite3 v5.1.6 and might work with more recent sqlite files and versions. SQLite Pro Tools also provide advanced shortcut commands and SQLite DB views.