Skip to content

Prepare for strict single quotes for string literals in SQL

Carlos Garnacho requested to merge carlosg/tracker:wip/carlosg/sql-literals into master

The lenient interpretation of double/single quotes has been described as a "mistake" by SQLite authors at https://www.sqlite.org/quirks.html#dblquote , and there are build/runtime toggles to switch to a more strict interpretation where single quotes are reserved for string literals and double quotes for tables/schemas/variables/etc.

This MR prepares for that eventuality, consistently using single quotes for string literals.

Merge request reports