Open the context
Choose the project folder and name the files or behavior involved.
Workflows
Coding workflows · SQLite identifier quoting
03
A concrete starting point
Quote one SQLite identifier by doubling internal double quotes and enclosing the result in double quotes. Check spaces and SQL-looking text in the name, rejecting empty names and NUL characters without treating a dotted name as multiple identifiers.
Define the change
Describe the input, expected output and boundaries that must stay intact.
Inspect the work
Review the proposed edits and any commands before relying on their result.
Check the outcome
Compare actual behavior with the expected result. If a check fails, investigate it before applying more changes.
SQLite identifier quoting
A concrete starting point
def quote_identifier(name):
if not isinstance(name, str) or not name or chr(0) in name:
raise ValueError("identifier.invalid")
return '"' + name.replace('"', '""') + '"'The example is a starting point for a real project, not a claim that generated code is already tested. Adjust paths, dependencies and expected behavior to match your application.