- Notifications
You must be signed in to change notification settings - Fork11
Pre-built SQL grammars that you can import and “just use”. No configuration necessary.
License
NotificationsYou must be signed in to change notification settings
modeldba/antlr4ts-sql
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Pre-built SQL grammars that you can import and "just use". No configuration necessary.
Supports MySQL, T-SQL (SQL Server), PL/pgSQL (PostgreSQL), PL/SQL (Oracle) dialects.
- Get parsers, lexers and parse-trees with a single method call.
- Determine if an arbitrary SQL script is syntactically correct.
- Identify the types of keywords used in the queries.
npm install antlr4ts-sql
import{antlr4tsSQL,SQLDialect}from'antlr4ts-sql';constantlr4tssql=newantlr4tsSQL(SQLDialect.MYSQL);constquery='SELECT * FROM table1';constparseTree=antlr4tssql.getParseTreeFromSQL(query);console.log(parseTree);// Sql_scriptContext {// _parent: undefined,// invokingState: -1,// _start: CommonToken { _line: 1, _charPositionInLine: 0, _channel: 0,// index: 0, _text: undefined, _type: 614,// source: { source: [MySQLLexer], stream: [ANTLRInputStream] },// start: 0, stop: 5// },// children: [// QueryContext {// _parent: [Circular], invokingState: 1212,// _start: [CommonToken], children: [Array], _stop: [CommonToken]// },// TerminalNode { _symbol: [CommonToken], _parent: [Circular] }// ],// _stop: CommonToken { _line: 1, _charPositionInLine: 20, _channel: 0,// index: 7, _text: undefined, _type: -1,// source: { source: [MySQLLexer], stream: [ANTLRInputStream] },// start: 20, stop: 19// }// }
antlr4ts-sql is a project created and maintained bymodelDBA, a database IDE for modern developers.modelDBA lets you visualize SQL as you type and edit tables easily with a no-code table editor.
About
Pre-built SQL grammars that you can import and “just use”. No configuration necessary.
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.
Contributors2
Uh oh!
There was an error while loading.Please reload this page.