antlr-plsql
antlr-plsql copied to clipboard
Your FOSSA integration was successful! Attached in this PR is a badge and license report to track scan status in your README. Below are docs for integrating FOSSA license checks...
- Clearer steps on how to build and develop - Instructions on how to run the ast-viewer locally
```sql SELECT id FROM artists WHERE id > 100 ``` ![image](https://user-images.githubusercontent.com/5768479/44840033-88ee4080-ac40-11e8-8aea-f92d0741b9f7.png) versus ```sql SELECT id FROM artists WHERE (id > 100) ``` ![image](https://user-images.githubusercontent.com/5768479/44840055-95729900-ac40-11e8-83ea-902730306333.png) Notice that the first image shows `where_clause`...
See [this example](https://ast-viewer.datacamp.com/static/index.html#/editor?code=SELECT%20local_name,%20subquery.lang_num%0AFROM%20countries,%0A%20%20%28SELECT%20code,%20COUNT%28%2a%29%20AS%20lang_num%0A%20%20%20FROM%20languages%0A%20%20%20GROUP%20BY%20code%29%20AS%20subquery%0AWHERE%20countries.code%20%3D%20subquery.code%0AORDER%20BY%20lang_num%20DESC%3B&start=sql_script&grammar=plsql) on ast-viewer.datacamp.com. A bunch of unshaped nodes.
For example, standard_function often allows an argument to be concatenation (which is now just another name for `binary_expression`). E.g. ``` COUNT '(' ( '*' | (DISTINCT | UNIQUE | ALL)?...
Moved from https://github.com/datacamp/sqlwhat/issues/45