Ability to detect & use variables in SQL Query
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
It'd be interesting if Postico could have a slide down menu that could detect variables in the sequel query. EX. if the query is SELECT * FROM table WHERE id = ${id} and it see's the ${id} in the string, it'd be able to show that as a variable we can change and that'd inject it into the query without having to change my variables to test sql queries when writing more complex ones.
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 with issue #339 and review how Postico currently handles SQL query input. Define the behavior for detecting ${id}-style variables, presenting editable values, and injecting them into the query without requiring manual edits. Done means a query such as the example can expose and change its variable values before execution.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100