openvax / datacache / 27777803905

73%

master: 79%

Pull #52

github

Fix #17: quote SQL table/column/index identifiers

Wrap every table, column, and index name in double quotes when building
SQL in database.py, via a new quote_identifier() helper that also escapes
embedded double quotes. This means identifiers containing spaces or
punctuation, or which collide with SQL keywords (e.g. "order", "group"),
no longer have to be sanitized down to alphanumeric + underscore.

Adds a regression test that creates and queries a table whose name and
columns contain spaces and reserved words.

Claude-Session: https://claude.ai/code/session_011bzfZPTzWnhAMVD7msyMg1

5 of 6 new or added lines in 1 file covered. (83.33%)

315 of 421 relevant lines covered (74.82%)

2.24 hits per line