manyuanrong / manyuanrong/sql-builder
Backtick is not SQL standard / doesn't work with PostgreSQL
Open
Nobody has claimed this yet.
enhancement
good first issue
- Dominant language
- TypeScript
- Stars
- 55
- Forks
- 15
- PR merge metrics
- No merged PRs in 30d
Description
The SQL:1999 standard specifies that double quote (") (QUOTATION MARK) is used to delimit identifiers. The backtick doesn't work with PostgreSQL.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the TypeScript code that generates identifier quoting for the SQL builder, then compare its output with SQL:1999 and PostgreSQL behavior. The work is done when generated identifiers use double quotes and the resulting SQL is accepted by PostgreSQL; add or run a focused verification if the repository provides one.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, sql, typescript
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100