SQLite 3.41.0 double-quoted string literals are disabled by default

[3tlam]

Hi all!

I ran into a nasty bug, where any SQLite Queries failed with Invalid table and it took a long time debugging it ;)
After talking to the hoster, I learned that as of SQLite 3.41.0 double-quoted string literals are disabled by default and therefore Kirby's check if the table exists fails.

Currently I don't have a good suggestion to you as to how to verify this, but I guess "just" changing it to single-quoted literals might fix this?

Kirby Version
afaik any, as the current implementation in this repo still has double-quoted string literals

Best
Malte

[3tlam]

re-reading the docs it seems as though there was no forcefully deprecation, but in any case, there is a reddit thread showing the same. Currently I am using SQLite Library 3.45.1, which is the same as in the reddit post.

So I guess it's not really a fault of the sqlite maintainers, but my hoster?