- Notifications
You must be signed in to change notification settings - Fork10
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
Stars
Watchers
Forks
Packages0
No packages published