This package is helper to implement very comprehensive, flexible searching, something like below.
| jql text | ( item is 'good' or item is 'so so' ) and date < now() |
|---|---|
| Transpiled SQL | (ITEM LIKE 'good' OR ITEM LIKE 'so so') AND DATE < NOW() |
We transfile jql text to SQL to support various searching 'and', 'or', '()', %keyword% and so on.
Please visit our live demo https://jql2sql.github.io/ to understand how jql2sql package works.
This package is consist fo three parts. JQL Parser, SQL Transpiler and Extended Function.
We implement our own JQL parser by using nearley. It parses jql text to AST(Abstracted Syntax Tree) for transpiler.
- To build JQL Parser
npm run build:parser
- To test JQL Parser
npm run test:parser
From AST, we transpile the tree to SQL.
npm run test:transpiler
Will be supported, Not supported yet.
You can define our own function to extend your searching like below.
field = myfunction(arg1, arg2) and date < now()
In security point of view, it's very dangerous due to SQL injection attack. So, we need our own grammar for searching, and it should be transpiled as SQL.
As Jira is famouse issue tracker, therefore JQL(Jira Query Language) has been used by many people. So, Rather than re-inventing wheel, we borrow JQL grammar.